J
James
I'd like to get hold of an object or collection representing the
(possibly multiple) charts that the user has selected. If the user has
only one chart selected then 'Application.Selection' returns a
'ChartArea' object and 'Application.ActiveChart' returns a 'Chart'
object, both of which would be fine. However, if the user has more
than one chart selected then 'Application.Selection' returns a
'ChartObjects' collection representing all the charts on the sheet
(not just the ones selected) while 'Application.ActiveChart' returns
'Nothing'.
I can't find a 'ChartObject.Active' or 'ChartObject.Selected' method
that would allow me to determine which of the "ChartObjects'
collection returned from 'Application.Selection'.
Any ideas?
Thanks,
James
(possibly multiple) charts that the user has selected. If the user has
only one chart selected then 'Application.Selection' returns a
'ChartArea' object and 'Application.ActiveChart' returns a 'Chart'
object, both of which would be fine. However, if the user has more
than one chart selected then 'Application.Selection' returns a
'ChartObjects' collection representing all the charts on the sheet
(not just the ones selected) while 'Application.ActiveChart' returns
'Nothing'.
I can't find a 'ChartObject.Active' or 'ChartObject.Selected' method
that would allow me to determine which of the "ChartObjects'
collection returned from 'Application.Selection'.
Any ideas?
Thanks,
James