I have tried with VB and C#. I also tried the same thing in VBA and get a
run time error 1004 - Application-defined or object-defined error.
The issue is that there doesn't seem to be a way to find out if a cell has
dependents.
C# code Excel.Range r = this.Application.ActiveCell.Dependents;
VB Code If (Me.Application.ActiveCell.Dependents IsNot Nothing)
Then
Any ideas on how I can get past this error or if there is another way to
find out if a cell has dependents before calling this property.
Thanks
Duncan