|
|
#1
04-20-2016, 06:08 PM
|
|||
|
|||
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? 
|
|
|
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 |
Windows 10 
Office 2016
Threaded Mode