Write a macro to change formulas


I have an excel Sheet1 and has formulas in column A. Some of these formulas refer to Sheet2 such as +Sheet2!A1, +Sheet2!A100, +Sheet2!578, .... I would like to find all these references and remove from the formulas in Sheet1 so it never refers to Sheet2. How can I do this, this needs to be done in all the rows in Column A, if this needs to be done in a macro what type of macro that can achieve this?

You could do this using Find/Replace. No macros required.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I see you have posted this question twice. Kindly don't do that.

Thread closed.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]