ExcelBanter - copying a chart

Hi
have a look at
http://peltiertech.com/Excel/Charts/...html#DelinkCht

--
Regards
Frank Kabel
Frankfurt, Germany

Marcotte A wrote:
I have a large (12+ MB) inventory/sales tracking spreadsheet. I need
to distribute the summary pages of this spreadsheet on a regular
bases (2-3x a week probably). I have a macro that will copy paste
special (values and formats) the summary pages, but there are also
charts I would like to copy. Whenever I copy them, they always refer
back to the original spreadsheet.

Is there a way to copy a chart and have it refer to the same ranges
on the sheet it is copied onto (these charts are embedded in
worksheets, not on their own sheet). Or do I have to write a macro
that will create the charts from scratch?