ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   List ranges a formula refers to (https://www.excelbanter.com/excel-programming/317639-list-ranges-formula-refers.html)

KL[_5_]

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




All times are GMT +1. The time now is 09:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com