Why aren't you simply using a template with Links to the Excel workbook & charts, which you could simply update and, if appropriate, break before saving the new document? That would make most of your code redundant and wouldn't require the use of bookmarks.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]