Activesheet.UsedRange.CopyPicture

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

--
Regards,
Tom Ogilvy


"Marc" wrote in message
...
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