Hi Jaymond,

I have to wonder why you're bothering to use Word at all. From what you've described, it seems to me the lot could be done within Excel.

In any event, to do it in Word, you don't have to select anything - simply tell it which range(s) to work with. As for the run-time error, that'll occur if you're using late binding. Try using '3' instead of 'wdPasteMetafilePicture'.

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