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