I have a workbook full of cell references and I need to add INDIRECT to all formulas. For example, I'd like the following formula...
=Table1!E6
... to become ...
=INDIRECT("Table1!E6")
I've done this before by finding and replacing the equals sign with =INDIRECT(" and then manually pasting in ") after every formula, but my current workbook is quite large. Any suggestions would be MUCH appreciated.
Thanks!
Bookmarks