Formula Range.Dependents - No Cells Found

[gs99]

What VBA code obtains information about formula dependents?

Help provides this format:
Range("A1").Dependents.Select

When I use this for a cell that has a formula, I get a VB message "No cells were found".

I really don't want to select it, I'm looking for code to obtain the "dependents" info, but the simpler select is not working.

Thanks,
George

 

[TonyJollans]

Hi George,

Dependents will only work within a single (active) worksheet - and, as far as I know, does work. Are you sure that (a) the sheet you want is the active one and (b) you have direct descendents on the same sheet.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[KenWright]

Works fine for me, subject to Tony's caveats about activesheet.

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[gs99]

Thanks, I had the terms reversed.

Precedents show the Cells referenced in a formula.

Dependents show the Formulas that reference a cell.

I'll try to picture President Bush showing me prison Cells.