Hello all,

Say I have an excel macro that runs on a weekly basis to generate 4
different charts in one worksheet. I now need to write a new macro to
select specifically the first and the third chart from the list of 4,
and paste the 2 charts to powerpoint. Does anyone have any idea how to
write a macro for this?

The difficulty I am facing is that, the 4 charts will not have a
standardized name, since the "Chart #" will keep on increasing when
the 1st macro regenerates new sets of graphs weekly. Is there a way to
get VB to select specifically the first chart as Object 1 and the 3rd
chart as Object 3 from the entire worksheet?

Hope someone can help. I am running out of ideas. Thanks in advance
for your help.

Rgds,
Mithi