What's the difference between .Dependents and .DirectDependents?

[baobob]

Of a range, that is.

Thanks.

***

 

[Ron Coderre]

DirectDependents are one level from the dependent cell
Dependents includes ALL levels.

Try this:

A1: 10
A2: =A1
A3: =A2

Select A1......Switch to the VBE immediate window
Enter: ? activecell.Dependents.Count
Return value = 2

Enter: ? activecell.DirectDependents.Count
Return value = 1

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Ron Coderre]

Clearer explanation (hopefully):

• DirectDependents all cells that directly reference the target cell.

• Dependents includes all cells that reference the
target cell, directly or indirectly.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[baobob]

Ron:

Thanks very much for your reply.

That's very clear.

***

 

[Ron Coderre]

You're welcome...I'm glad I could help.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)