Just use the name of the chart sheet as listed in the sheet tab. For the code
example, I used "Sales Data". As no doubt you are already aware, you can
change chart sheet names the same way you can worksheet names, by
right-clicking the tab and selecting the Rename option.
Regards,
Greg
"Mark Stephens" wrote:
Hi Greg,
Thanks for that but does it work for a chart sheet as well as a chart
embedded in a workbook? If so how do you find the name of the chart in
your chartsheet?
Thanks for your help, Mark
*** Sent via Developersdex http://www.developersdex.com ***