Thanks Luke, I was not familiar with the camera tool so i added it to the ribbon and then recorded a macro to see how it works. When I try to run the macro, it breaks in the 3rd line (see code below). I simply used the tool to take a screenshot of a graph and pasted the image on the same...
I need code that will take a "partial" screenshot of the active sheet and paste it into the body of an Outlook email. The "partial" screenshot could be defined by some sort of OFFSET code, or by directly naming the XY coordinates of the screen....please help...