Macro to find values of each cell referenced in a formula
Posted by Kent Felgner on December 14, 2001 4:58 AM
Any ideas on how to dissect a formula and retrieve the individual referenced cell values.
For example, if Sheet1 is a summary sheet containing hundreds of summarized cells and Sheet2 has the detail (i.e. Sheet1!A1 = Sheet2!B1 + Sheet2!B20), how can I create an outline (i.e. Sheet3!A1 = Sheet1!A1, Sheet3!B2 = first cell referenced in formula, Sheet3!B3 = second cell in formula, Sheet3!B4 = third cell referenced if applicable....)
I can use .hasformula to find the cells to dissect but how do I take apart and find the values of each cell in the formula.