What is Selected?

  • Thread starter Gary''s Student
  • Start date
G

Gary''s Student

How can I determine or identify what is Selected on the ActiveSheet? Is it a
cell or group of cells? Is it a Shape or Chart or something else?
 
P

Peter T

s = TypeName(Selection)

If that returns "Range" go on to examine the range object, eg
Selection.Areas.Count ' if >1 it's a multiple selection
Selection.Count ' if =1 it's a single cell

With objects Selection returns the name at the DrawingObject level, eg
"Rectangle" or if multiple "DrawingObjects". With an Active chart it'll be
the name of the chart element, eg PlotArea, Series, Point, etc

Regards,
Peter T
 
G

Gary''s Student

Thanks!
--
Gary''s Student - gsnu201001


Peter T said:
s = TypeName(Selection)

If that returns "Range" go on to examine the range object, eg
Selection.Areas.Count ' if >1 it's a multiple selection
Selection.Count ' if =1 it's a single cell

With objects Selection returns the name at the DrawingObject level, eg
"Rectangle" or if multiple "DrawingObjects". With an Active chart it'll be
the name of the chart element, eg PlotArea, Series, Point, etc

Regards,
Peter T




.
Click to expand...
 
Top