View Single Post
  #4   Report Post  
Tushar Mehta
 
Posts: n/a
Default

While John and Debra have given you the technical solution, I don't know
how useful they will be. You have to have some way to identify each of
the charts *before* you rename them. Otherwise, how will you know what
name to assign to what chart?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
I have a lot of charts in a woorkbook and need to refer to them in my VBA. I
cannot know the names (numbers) of all the charts. mHow can I change a
chart's name so it is easy to find them ?