Dependents

[JerryGiese]

Is there a way to count the number of dependents or list the dependents of a cell using VBA?

Thanks,
Jerry

 

[lenze]

Something like this

Sub depend()
    MsgBox Range("$B$1").Dependents.Count
End Sub

lenze