Unintended cell reference updates when running macro

Hi,

I want to add the Excel ROUND function to numerous existing cells on multiple worksheets and using find/replace will not work (as far as I know) as I would need to make two passes to add "ROUND(" to the front of the existing formula and ",0)" to the tail end of the formula (Excel complains/rejects the first update indicating the formula is inconsistent). So, I tried creating a macro that does both parts at once by finding a keyword at the front of the formula, replacing it to add the "ROUND(" text, and then going to the end of the formula to add the ",0)" portion. But, when I run the macro, it ends up with an unintended result of also converting cell references in the formula as they do not use the '$' feature. There must be an easy way to accomplish what I want to do other than editing each cell and would appreciate hearing of a way(s) to perform this task.

Thanks,
Nick

Can we see your code?

Dom

This would be how I would do it:

Please Login or Register  to view this content.

Dom