View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
tom tom is offline
external usenet poster
 
Posts: 570
Default Chart object number

I have a number of charts in my worksheet that I would like to copy to a word
document. I am thinking the best way is to:

1. select the chart object
2. copy it
3. Tthen open a Word doc (not sure about the code for this)
4. paste it in the word doc

How can I get the chart object number to select the chart? for example if I
have 200 charts they are not always numbered sequentially from 1-200
depending on how many times the charts are created. I may have a chart 299,
then a chart 333. How do I go the chart object number to be able to
reference it and select the chart.