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