Trace Dependents Loop EdD Jan 28th 2003 You could use an input box to alter the range or hard code it to a different cell.Ed
Trace Dependents Loop EdD Jan 27th 2003 HiThe code below colours all b1's dependents magenta this can be amended to delete or whateverFor Each t In Cells.Range("B1").Dependentst.Interior.ColorIndex = 7NextHope this HelpsEd