Returning the name of a chart
 

Jon Peltier helped by explaining how to see the name of a chart by
Ctrl+click on it. Is there a way of selecting a chart of unknown name -
say by clicking on it - and returning the name to use in code for
subsequent operations eg returning to it, or renaming i?


*** Sent via Developersdex http://www.developersdex.com ***

Returning the name of a chart
 

One way...
Dim x As String
x = ActiveChart.Name
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Gordon Humphreys"
wrote in message
Jon Peltier helped by explaining how to see the name of a chart by
Ctrl+click on it. Is there a way of selecting a chart of unknown name -
say by clicking on it - and returning the name to use in code for
subsequent operations eg returning to it, or renaming i?
*** Sent via Developersdex http://www.developersdex.com ***

Returning the name of a chart
 

If it's an embedded chart, use ActiveChart.Parent.Name

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim Cone" wrote in message
...

One way...
Dim x As String
x = ActiveChart.Name
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Gordon Humphreys"
wrote in message
Jon Peltier helped by explaining how to see the name of a chart by
Ctrl+click on it. Is there a way of selecting a chart of unknown name -
say by clicking on it - and returning the name to use in code for
subsequent operations eg returning to it, or renaming i?
*** Sent via Developersdex http://www.developersdex.com ***