Identifying and naming chart objects in Excel

[TomYC]

I have inherited a workbook with numerous very similar worksheets. Each one has a chart on it.
I have a macro that does something to the chart (specifically it copies it to clipboard, deletes it and then repastes it as a picture w/o links.
Usually the macro works, but when it doesn't, it is because the chart on the worksheet is not named 'chart1' probably because in developing the worksheet, earlier chart objects were created and discarded.
So I would like to a:
Find the name of the existing chart object;
Rename it if possible (to chart1 or something standardized);
Then skip to the next worksheet with a chart (two worksheets away) and run again. I'll settle without the latter, but I'd really like to select a worksheet, and run this macro without worrying about which worksheets have it named chart1 and which have it named chart3 or whatever!
Tnx

 

[SkipVought]

Hi,

Then you must be using some VBA code.

Please post your code and question in forum707, where it can be properly addressed.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}