Thread: referring to a chart without using its name??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default referring to a chart without using its name??
Hi Neowok,

So I need to find out if its possible to reference the charts for
printing by the sheet i.e. chart15.printout or something like that
rather than the name.

You have already correctly answered your own question, use the charts
codename.

From the intermediate window:

?Charts("Chart1").codename
Chart1

Charts("Chart1").name= "FirstChart"

?Charts("FirstChart").codename
Chart1


---
Regards,
Norman




Reply With QuoteReply With Quote