I have 25 charts based on dynamic ranges and featuring links to other
workbooks.

My question is actually twofold:-

1. The charts all update themselves fine. I have about four
charts per spreadsheet and I need to distribute the charts themsleves,
but without the underlying data. What is the best way to do this.
And what is the best way to do this programmatically.

2. I had assumed that he best thing would be to create reports by
Shift-Copying the charts as they look on the screen to tables in Word
and then formatting the document as is, but I think the code here to
format Word into different sections, with different headers and
footers, creating tables in Word to hold the charts (four per page -
landscape) would have been too complicated.


What would people recommend here? All I really need to do is to email
the charts four specific charts per page so that they can be printed
out!



Richard




Its a good job Einstein never had to fill out one of these Government Grant applications or we never would have found out what e equalled. The West Wing