Parse Precedents/Dependents from Formulas

[btorrean]

Dear Forum Users,

I have come upon a situation where I need to parse precedents/dependents from user formulas in a workbook. Excel's built-in '.Precedents' and '.Dependents' do not return all precedents or dependents. For example, if I have a two-sheet workbook and a formula on Sheet1 references a range on Sheet2, Excel does not return the Sheet2 dependent. Also, for named ranges, Excel returns the actual range address, not the name of the range. Does anyone have any insight into this?

Brian

 

[Andrew Poulsom]

Maybe this will help you:

VBA for Checking Dependencies on Other Sheets

 

[btorrean]

Andrew,

Thanks for the reply. That works pretty well, though I should have been more clear. I am looking to trace precedents in code, but I also have a static list of formulas, from a report, that I have to parse. The formulas are currently stored as text. I need to pull out any references to named ranges and static cell ranges. The ranges can be in other workbooks, and are not linked to the report workbook in any way. Is there a way to do that? Should this be started as a separate thread? Thanks again for the help you have already provided!

Brian