#1
|
|||
|
|||
Write a macro to change formulas
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? |
#2
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to change this printing macro | terrymac | Excel Programming | 1 | 12-01-2015 06:47 PM |
Macro to change cell references | SaneMan | Excel Programming | 6 | 10-01-2013 02:49 PM |
write need help and copy write need help on another page auto | wykoems | Word | 2 | 07-25-2013 07:56 AM |
How do you write a macro with an IF Function | Scheuerman1987 | Excel | 5 | 06-05-2013 06:04 AM |
How to write a macro to find a specified name in a list of data? | Jaffa | Excel | 1 | 10-23-2010 02:39 PM |