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
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
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.