#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 could do this using Find/Replace. No macros required.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
I see you have posted this question twice. Kindly don't do that.
Thread closed.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Write a macro to change formulas | Xyz_999 | Excel | 1 | 04-20-2016 09:51 PM |
How to change this printing macro | terrymac | Excel Programming | 1 | 12-01-2015 06:47 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 |