Macro to copy/paste range as an image...

I have successfully created a macro that, when clicked, copies a certain range of cells A1:A7 (example).

Here's the code...

Please Login or Register  to view this content.

But, what I can't seem to accomplish is the ability to select multiple ranges, from multiple sheets. Is there a way to accomplish this?

When I run the following code...

Please Login or Register  to view this content.

1. With both sheets, and both ranges, I get an error that says, Subscript out of range

2. With one sheet, but both ranges, I get an error that says, That command can only be used on multiple selections

Is there something I can do to accomplish the goal I'm trying to get to?

-Jared

Hi Leith,

Yes. That's correct. I'm trying to pull data from multiple sheets, and ranges and copy that information as an image. Then, I'll paste it where I see fit.

Yes. That's where I'm trying to get to. But I can only seem to copy continuous ranges from one sheet. Can you help?

The workbook is attached.

If you uncomment the commented out portion of the VB, it will auto-paste in the same workbook.

And how might I pull data from multiple sheets?

I'm still not able to come up with anything. Any ideas?

Are you still there?