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