Editing Formula Macro

[yoitsmejy]

Hi,

I am trying to write a macro to edit formulas. I need a macro to delete part of the formula. I assume that its string related but i am not sure how to go about it.

For example:
I would like to delete "cols=5;rows=3246" from the formula.The following is located toward the end of the formula.

Please advise. Thank you.

[Bob Phillips]

Just do a Find and Replace, Ctrl-H

[yoitsmejy]

I was thinking of that but i would like to create a macro that will run through multiple sheets and the cols and rows are different for each sheet

[Bob Phillips]

So record the Ctrl-H and then embed that code in a more generic macro.