Thread: Need to identify object selected.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
pikus pikus is offline
external usenet poster
  
Posts: 1
Default Need to identify object selected.
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

Reply With QuoteReply With Quote