View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Selecting objects

Your trying to see if multiple objects are selected

Demo'd from the immediate window:
? selection.count
3
? selection(1).Name
Rectangle 6
? selection(2).Name
Oval 7

so use
if selection.count 1 then
' multiple objects selected

--
regards,
Tom Ogilvy



"Mike" wrote:

If the user has multiple objects selected, I want to do something. If you
have one object selected, and use Selection.Name it gives the name of the
object. If you have multiple objects selected, it gives an error. So I
thought I could do this:

If Selection.Name Is Error Then (do whatever)

But it doesn't work. Any ideas?