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