Need to identify object selected.

N

Neil Bhandar

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
 
P

pikus

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
 
D

David

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.
 
R

Rob van Gelder

Neil,

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


Rob
 
Top