VBA: Export excel range as image and save as file.

PROBLEM: How to save Excel range into image file. VBA macro in Excel 2007.

SOLUTION: Create an empty chart, paste range image into chart area, and Export as image file.

Modify code to suite to your needs.

Code snippet - VBA: Export excel range as image and save as file. on Snipplr

from http://snipplr.com/view/54755/