Hello all,

I have made an excel file with 2 separate sheets in it. I need make a button which takes a screenshot on sheet one with the range A1 to K31 and on the second sheet from B2 to I43 and combines them into a single JPEG image saved on my desktop (Preferably with sheet1 image on the left).

I have no idea how to do something like this and any help would be greatly appreaciated.

Thanks,

ABourdages