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 don't need a macro for this.

Try the following:

Select the range with your formulas.
Press Find&Select on the ribbon.
Press Replace.
In Find what field enter =.
In Replace field enter x.
Press Replace All and press OK to All done.

Press Replace.
In Find what field enter Sheet2!.
Leave the Replace field blank.
Press Replace All and press OK to All done.

Press Replace.
In Find what field enter x.
In Replace field enter =.
Press Replace All and press OK to All done.
Press Close.