Dependents Property Example

This example selects the dependents of cell A1 on Sheet1.

Worksheets("Sheet1").Activate
Range("A1").Dependents.Select