Finding chart on worksheet

[Guest]

I am making a macro that will use the chart on the worksheet. However, the
chart may be "Chart 1", "Chart 2", or any other number. I will only have one
chart on the sheet. Is there away to find this "chart"? I want to use it for
other macro programming. Thanks!

 

[papou]

Hello Mike
How about:
Worksheets("Sheet1").ChartObjects.Item(1).Name

HTH
Cordially
Pascal

 

[Guest]

Thank you! This worked! I appreciate all the help!

 

[papou]

You're welcome, thanks for your feedback.
Cordially
Pascal