I have been having problems with incorrect calculation of column totals when
using the SUM function. The data I have entered in the column to 20 decimal
places are as follows: 7.4, 10,14.7 and -32. These should total 0.1 but
excel calculates the total as 0.09999999999999430000

Would anyone happen to know the correct syntax to reference an object that
resides in a file outside of excel?  
Here's what I'm trying to do: I've created a class module named Person.  I
want to move it out of the spreadsheet it is currently in, and into a file

Is it possible to have conditional formatting on a field in a pivot table.
I can apply conditional formatting to a range of cells, but if e.g. a wider
range of data is produced the formatting doesn't grow with it.  I don't want
to have the 'Grand Total' columns have the same ...

I do many files where I have to lock the cells for users,
Is there any way to make excell unlock every cell that is empty and
lock every cell which contains data or formulas in ?
regards

Does anyone have any example worksheets from the body shop business or any
that are used with a form that I can just type the information in a form and
it willl put it in the worksheet for me?

Hi, I have code that sends mail with some files, but there is
something wrong becouse always next reciepent recive dedicated
attachement + all atachements send already to previous reciepents ?
What should I do to make my user form active on the excell start.

how do you link sheets together, like i have i the totals in 5 or 6
different sheets and on the last sheet i want the grand total. i need help!!

i am using excel 2000. i cannot edit and save a existing file.
the file is not protected,not read only and not shared.
when i open the file, a Microsoft excel window appear saying "File is
locked. In order to save changes to the file, you can either close the file

I have seen this posted in another newsgroup but did not understand the
answer.  I have copied many names/address and pasted them into Excel.  All of
the info is sitting under one column.  I would like to find out how to
seperate the info into multiple columns so that I can ...

We use a Sales Order template d/led from MS many years ago.  I now need to
use the same template, but without the macros.  Unfortuantely, when I try to
remove the macros from a copy of this template, I find they are password
protected.  Does anyone know how to get rid of them?  ...

I've been working on quite a large worksheet, and after about 5000 rows, I
realized I forget to hit F4 and $$ the referenced cells. Is there a way to
highlight a large area, and have it do the whole thing at once?
Thanks,

OK, I have a column and in the top cell of the column I have the number of
days holiday an employee is entitled to. Now, every time I enter, say the
letter H in the column for each days holiday taken, I want it to
automatically deduct a day from the number in the first cell of the ...

I want to loop through a range of cells starting at D5 and then going as far
to the right and down the spreadsheet as there are values in the sheet.
For each cell I want to be able to color code the background of the cells
depending upon the following criteria

Dear Group,
I cannot think of how to do this:
Say A1:A5 contain numerals.  B1 contains a numeral, say 6.  C1
contains =SUM(A1:A5).