If you copy an Excel range and paste it into Word using Paste Special with the 'Paste Link' option and choose an appropriate format, the Word document will be linked to that Excel range. Any changes to the Excel range will be reflected in the Word document. No code required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|