How do I verify if I have selected an object other than a
cell or a range of cells?

Can any one pls help.

Thanks,
-Neil

If it is only one or if it many cells, the code is the same:

var1 = TypeName(Selection)
If var1 < "Range" Then
DoStuff
Else
DontDoStuff
End If

- Piku

--
Message posted from http://www.ExcelForum.com

Not sure if this will work or help. NameType(activeobject)
If you can stop the code where you want this might help
in the immediate window.

-----Original Message-----
How do I verify if I have selected an object other than
a
cell or a range of cells?

Can any one pls help.

Thanks,
-Neil
.

Neil,

Sub testit()
If Not TypeOf Selection Is Range Then MsgBox "Selection is not a range"
End Sub


Rob

"Neil Bhandar" wrote in message
...
How do I verify if I have selected an object other than a
cell or a range of cells?

Can any one pls help.

Thanks,
-Neil