You could use an input box to alter the range or hard code it to a different cell.
Ed
You could use an input box to alter the range or hard code it to a different cell.
Ed
Hi
The code below colours all b1's dependents magenta this can be amended to delete or whatever
For Each t In Cells.Range("B1").Dependents
t.Interior.ColorIndex = 7
Next
Hope this Helps
Ed