Need to identify object selected.

  • Thread starter Thread starter Neil Bhandar
  • Start date Start date
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
 
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
 
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.
 
Neil,

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


Rob
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drawn Objects Q 2
VBA set thick borders around non empty cells in range 0
Write a button to run macro on *ANY* chart area clicked. 1
Select range 3
Excel VBA 1
Code to add comments to selected cells within a selected range 30
Code for multiple select of cells 16
Import multiple workbooks to current workbook in specified row number 0

Back
Top