I'm trying to count all cells in a range that have a diagonal lin
accross the cell but so far no luck! :confused:
Background:
The Worksheet is an audit schedule and when an audit is completed

Using a line chart, is it possible to have scaling appart from the
Y-axis to the x-axis, regardless the kategory-values of the x axis?
For example the values of x to establish some points are 5, 15, 30 etc.
is it possible to put them on scale as well on the chart?

Is there a way to copy a customized Excel toolbar from one PC to another?
tia,
sh

Hi gurus...
I would like to run it by you, experts... Here is the problem: I woul like
to build a macro that format the text so that the first letter of each word
is a capital...

how is most easy way for finding workbook (for example data.xls) is open?
Thanks Tom

now how can I lock all macros and forms againts editing? Its possible do
that in Workbook_open(), or I have to do it in VisualBasic Editor?
Thanks
Tom

I searched but could not find the answer then Boom I stumbled upon it o
my own. Anyway here it is:
To use Quotes in a CONCATENATE formula use two quotes next to eac
other. I am sure most here knew that but I have been using Excel for

I have created a mail merge document in Word2002, using Excel2002 for m
data source.  When I merge the document, some of my fields hav
incomplete data.  The only records affected are those where the dat
from the Excel fields is fairly long.  Only about 200 characters wil

I've been given this task to do in Excel and I need help.
I have a column/list in worksheet2. The list is indexed and must stay intact
as many cells in the workbook use this list.
Lets say in this column I have the following information:

Hi Friends
Greetings. If I have the following 500 row excel file, how can we get the
subtraction of first two columns(Col3)?. I couldn't find any subtraction
function in microsoft excel 2000.

Hi I have a list of files in an excel sheet in the first column I would like
to know is there a way I can get excel to search for these files by giving
it a dirctory and then it would copy the files to a directory I set, so say
I have the following in an excel document

Hope someone here can help me out.
Upgraded from Excel 97 (Word too) to Office Pro 2003 installing everything
on an XP Pro desktop connected to a network running Microsoft SBS2000.
Now, when I simply open Excel, I get:  "The file cannot be opened because

I have problem openning an excel file from windows explorer or from my
desktop. However, when I open the excel program and open a file
manually(File-Open----) everything works fine.
I get an error message that the file could not be located. I noticed

now I need protect macro (againts using Ctrl-Break) in Sub Auto_open(), but
this dosnt work:
       With Application
           .EnableCancelKey = xlDisabled