I perform an intersection, but sometimes the result is nothing. I have not been able to find a means to test if isect is nothing.
Set isect = Application.Intersect(SourceSelection, Range("A10:A65000"))
I want the equivalent to:
If isect = "nothing" then msgbox "No relevant data."
Thanks.
This message was edited by Brian on 2002-05-20 14:47
This message was edited by Brian on 2002-05-20 17:23
Set isect = Application.Intersect(SourceSelection, Range("A10:A65000"))
I want the equivalent to:
If isect = "nothing" then msgbox "No relevant data."
Thanks.
This message was edited by Brian on 2002-05-20 14:47
This message was edited by Brian on 2002-05-20 17:23