Formula Range.Dependents / Range.HasFormula

[gs99]

How does VBA obtain 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.

Also, with Range.HasFormula, if a cell has "=D1", is this not considered a formula? My code says no. But isn't D1 a dependent?

Thanks,
George

 

[gs99]

Update on Range.HasFormula, if cell has "=D1", it's working now.

Thanks,
George

 

[gs99]

Sorry, wrong forum.