Macro to Screenshot Excel and Paste Image to MS Word

[ramlineses]

Hello,

Is there a macro code that will screenshot a specific group of cells in a worksheet and paste it in MS Word as an image when a button is clicked?

Specific cells - columns A to AJ, rows 1 to 70

Hoping for your help on this. Thank you.

[ikboy]

Try this:

[ramlineses]

hello, thanks...I will try this now and will get back to you

[ramlineses]

not working

[macropod]

Is there a macro code that will screenshot a specific group of cells in a worksheet and paste it in MS Word as an image when a button is clicked?

Specific cells - columns A to AJ, rows 1 to 70

That's a huge range to paste as a single picture. While it can be done, the picture would probably be illegible. That said, you could use code like:

Please Login or Register  to view this content.

The above code copies A1:AJ70 from the active sheet and pastes it into a Word document named 'Document Name.doc' in your Documents folder, at a bookmark named 'myBookmark'.