List ranges a formula refers to
Is it possible to determine the ranges a worksheet formula refers to and
list them for further use in code? For example if on te spreadsheet I have
the following formula:
=SUM(A:A)-AVERAGE(1:1)+A1-$C3*SUMPRODUCT(($B$1:$B$200=3)*$B$1:$B$200)...
I would like to have a list like this:
{"A:A", "1:1", "A1", "C3", "B1:B200", "B1:B200", etc...}
Thanks a lot in advance,
KL
|