somnath_it2006
Well-known Member
- Joined
- Apr 11, 2009
- Messages
- 574
Hi All,
Today I found something strange in excel utility.
Below is the code from class module where I have used WithEvent and get the all worksheet events.
Whenever I on the "Euro Currency Tool" utility from Add-Ins, above code does not works properly. It gives correct output from line "TestCheck = Target.Dependents.Cells.Address" but as well as generates the error code 9 (Subscript Out of Range).
If I off or uncheck the "Euro Currency Tool" from Add-Ins, then it works fine.
I don't know whats going on....
Please suggest.... because this code is the part of our company utility I have solve this.
Today I found something strange in excel utility.
Below is the code from class module where I have used WithEvent and get the all worksheet events.
Code:
Dim Cell As Range
Dim Msg As String
Dim TestCheck As Variant
On Error Resume Next
[COLOR="Red"]TestCheck = Target.Dependents.Cells.Address[/COLOR]
If Err.Number <> 0 Then
Exit Sub
End If
Whenever I on the "Euro Currency Tool" utility from Add-Ins, above code does not works properly. It gives correct output from line "TestCheck = Target.Dependents.Cells.Address" but as well as generates the error code 9 (Subscript Out of Range).
If I off or uncheck the "Euro Currency Tool" from Add-Ins, then it works fine.
I don't know whats going on....
Please suggest.... because this code is the part of our company utility I have solve this.