Tuesday, February 14, 2012

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.

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