I've got a large spreadsheet with multiple indirect formulas built into it. I need a macro to convert all of these indirect formulas into their corresponding standard references.
Cell C1 Contains "B3"
I need a macro to convert the indirect formula to =B3.
This is a very basic example the file has formulas in it such as :
I've seen a lot of posting from folks but can't seem to get any of them to work.