S
sm34gm
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
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