prevent a macro from removing any formulas that are on the worksheet?

[daillest319]

is there anyway i can prevent my macro from removing any formulas that i have on my worksheet? For example is i add the total sum to one colomn. I dont want to lose it once i use the marco.


This is the code im using..

Please Login or Register  to view this content.

[swoop99]

If you specify a cell reference in your macro and tell it that cell(ref) = "whatever" then no matter what you do, the contents of the cell will be overwritten.

The only way to ensure cells are not overwritten is either, a) make sure you do not reference any cells that aren't supposed to be overwritten in your macro or b) have a qualifier such as:

Please Login or Register  to view this content.