malik641
10-08-2005, 10:39 AM
What would be the proper code to write something like:
If Range("ThisRange") is non-Existent Then
MsgBox "Range doesn't Exist"
Exit Sub
End If
I've tried
If IsError(Range("ThisRange")) Then
MsgBox "Range doesn't Exist"
Exit Sub
End If
'I've also tried
If IsMissing(Range("ThisRange")) Then
MsgBox "Range doesn't Exist"
Exit Sub
End If
But I've had no luck with this http://vbaexpress.com/forum/images/smilies/090.gif
Any ideas??
If Range("ThisRange") is non-Existent Then
MsgBox "Range doesn't Exist"
Exit Sub
End If
I've tried
If IsError(Range("ThisRange")) Then
MsgBox "Range doesn't Exist"
Exit Sub
End If
'I've also tried
If IsMissing(Range("ThisRange")) Then
MsgBox "Range doesn't Exist"
Exit Sub
End If
But I've had no luck with this http://vbaexpress.com/forum/images/smilies/090.gif
Any ideas??