Macro to take screenshot and save as picture file in same directory

superskid

Board Regular
Joined
Aug 25, 2006
Messages
158
Is there anyway that I can create a macro that will take screenshot of a set range of cells and then save that image in the same directory as the excel spreadsheet with the file name:

"(text from cell C4) Dashboard - (text from cell C2)"

* Note: Cell C2 is a date formatted m/dd/yyyy I would want the file to use text ie: January 1, 2014
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Watch MrExcel Video

Forum statistics

Threads
1,108,969
Messages
5,525,961
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top