Precedents and Dependents

Hi

As a part of a macro I am trying to figure out the functionality of Dependents and precedents. I've pretty much understood the concept of Precedents and have been able to use them in macros.

So this macro i'm writing would have 2 basic conditions:
1. Precedents.Count = 0
2. Dependents.Count <> 0

Please Login or Register  to view this content.

Basically, the macro should test that, firstly, A1 is not a formulae itself and secondly, alteast one of the cells in the active worksheet is linked to A1.

Now I'm able to get the precedents thing to work. But the 'Dependents' is not working. Rather new at this mind you

Where am I going wrong?

Thanks in advance

You will get a debug if no dependents/precedents can be found so you should capture with Error Handler etc... eg:

Please Login or Register  to view this content.

Is that what you meant ?