Excel

VBA - Save range as image

Ivan F Moala

Can Do

Visits here

Greatest place to be

Thanks for visiting my site lucky visitor:

This page was last updated on: August 14, 2007

There are times when you may need to save an Excel range selection as an image file. I use this all the time to save images to try and explain something easier, remember a picture is worth a thousand words. Also used this for this sites images where applicable.

If you wanted to take this further then consider these options......

1) What about saving a range as an image AND then displaying it on a Userform.

2) Saving a range as an image and emailing it (see here for one way)

3) Saving an image of a chart WHEN the data range changes and displaying it in a comment

To see example code for displaying an image in a comment see here.

4) Saving an inserted image in a spreadsheet. The Html maker ustilises this technique.

As you can see, the posibilities for it's use are up to you....in fact I have done all the above.

Here is a routine that can do this for you.

Enjoy

Get an example workbook here

If you cannot see the Code Window below then Click here

Update:

Here is another method of doing this .................