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

Of a range, that is.

Thanks.

***

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

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)

wrote in message
...
Of a range, that is.

Thanks.

***

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

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)


"Ron Coderre" wrote in message
...
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)

wrote in message
...
Of a range, that is.

Thanks.

***

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

Ron:

Thanks very much for your reply.

That's very clear.

***

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

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

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

Regards,

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

wrote in message
...
Ron:

Thanks very much for your reply.

That's very clear.

***