Hi all,

I have made a macro to perform an operation on all cells that
dependents of a specified cell. I want to exit the macro when the
specified cell has no dependents. Whatever I try causes an error.
Please could you give me some ideas how to achieve this effect? Here's
an example of what I tried:

If masterCell.DirectDependents.Count = 0 Then
Exit Sub
End If

but even the count property is invalid when the cell has no
directdependents.


Thanks, smu