VBA to copy a worksheet to word as a picture

  • Thread starter Thread starter Marc
  • Start date Start date
M

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
 
Activesheet.UsedRange.CopyPicture

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