VBA to copy a worksheet to word as a picture

[Marc]

Hello,

I'm trying to find some VBA code that will copy a
worksheet, from excel (2000), and paste it as a picture
into word (2000).

I have found a few online but they don't copy it as a
picture and/or copy all the sheets in the workbook.

I look forward to anyones help.

Thanks you in advance

Marc

 

[Tom Ogilvy]

Activesheet.UsedRange.CopyPicture

Puts the range in the clipboard as a picture.
See help on CopyPicture for details.