What is Selected?

  • Thread starter Thread starter Gary''s Student
  • Start date 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?
 
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
 
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




.
 
Back
Top