Brian,
I think your suggestion of naming the chart as you create it is the way to
go.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Brian Murphy" wrote in message
...
Andy,

I've come across an interesting twist on this multiple chart selection
story. Sometimes it works great, but sometimes not.

I use code to create a series of charts on the user's worksheet by
copy/pasting a chart template from a template workbook. In excel 2003
those charts would end up with .Name properties like Chart 1, Chart 2,
etc. But in Excel 2007 they all take on the same name property equal
to whatever the .Name property was in the template workbook. Most
importantly - they all have the same .Name property if made from the
same template, which is really weird.

The loop does not work in this situation. In fact, I can tell
something strange is happening because Excel 2007 acts rather funny
when holding down the shift and/or control keys while trying to select
several charts. What ends up happening is the loop acts on the same
chart each time through the loop.

I think I need to change my code to specifically give the pasted
charts unique Name properties. Unless you can suggest a better
approach. I haven't done this, yet. That's what I intend to work on
next.

Brian