Hi,

I have a worksheet I am copying which contains many formulas. When I copy
the sheet, all of the formulas copy except 3. For these 3 cells, if there is
a value, it copies the value only. If there is no value, it copies the
formula. It must be some setting on the cells themselves as the others are
fine. I have been unable to find it. The cells are formated General with no
conditional formating. I have checked that the formulas are not hidden.

Here is the code I use to copy the sheet.
CAMMaster.Copy After:=Sheets(ShNumber)

Does anyone have any suggestions as to what this might be?


Thanks for your help.
--

Karen