Hi Guys

I've just gotten back on to this after a break and applied
the logic you suggested in your winter post.

Everything worked fine until I opened a chart and tried to
change the chart type to the one that was added in the
macro.

I got the MS Office "Do you want to send a crash report to
Microsoft" error.

I can save this chart manually and then use it fine. It's
just the automatic one that is crashing.

Any ideas of what I could look at?

Thanks
Derek


-----Original Message-----


Sandy V wrote:
Derek
Looks like Jon Peltier & I were following up at the
same
time. As he has previously suggested similar but
better
(I hadn't seen his "winter post") I think you can be
more
confident this is the way to go.

Re use a different method
See Jon's code

Regards,
Sandy

PS to Jon
In our last exchange in May you mentioned

Isn't that fun.

to which I meant to reply - "No !"


Sandy -

I don't remember, but my tone of voice sounds familiar!

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______


.