Posts by EdD

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