How to write VBA to copy range and save into .JPG ?

[sthanawa]

Hello All ,

I would like to know how to write VBA code to copy a specific range in Excel and then save it in .JPG format ?

Please suggest.

 

[Domski]

Hi,

You can copy charts or ranges and save them as pictures using the copypicture method like this:

Sub Copy_Range_As_Picture()

Range("A1:B10").CopyPicture xlPrinter, xlPicture

Sheets("Saved Stuff").Activate

Application.ScreenUpdating = True

Range("A1").Activate

ActiveSheet.Paste

End Sub

Hope it helps,

Dom

 

[sthanawa]

Hi Domski ,

Thank you for your suggestion. I tried to run your code already. It just copy and paste them as picture to other sheet.

How can I paste into other program and save to .JPG ?