Macro to Screenshot Excel and Paste Image to MS Word

Originally Posted by ramlineses

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'.