Sizing Pasted object into Word

[Bob1980]

Hello all,

Thanks for all of the support this forum has gave me. After a few months, I'm manipulating arrays, loops, userforms, and buttons. Today, I'm running into a little bit of a problem and my searches are not pulling up anything useful. I'm trying to create a macro that will cut and paste a predetermined range into a word document. Below is the macro:

Please Login or Register  to view this content.

The only problem is that when the object gets pasted into the word document, it is too large to fit onto one page. Is there a way to automically size the object so that when it get's pasted, it doesn't bleed over the edges and stuff?

Thanks,
Bob1980

[Bob1980]

Hello all,

for those of you following this post, I figured out a work around; which is actually much better then copying and pasting the ranges. Below is the solution:

Please Login or Register  to view this content.

So, instead of copying and pasting the range, I'm using a special paste to paste an image into the word file. So, now I'm just trying to figure out how to paste multiple images into the same word file. If anyone can offer some guidance on this, I'd be very grateful.

Thanks.

[Bob1980]

Hey All,

I've figured out how to do this. Below is my solution. I hope it helps some other people out.

Please Login or Register  to view this content.

Thanks