Saving a Camera Tool Snap shot

[Northrun]

In Excel 2010, I used the camera tool to take a snapshot of a selction of cells. How do I save the snapshot only as a JPG or GIF file?

I know that there are programs outside of Excel that can take snapshots or print screens, but I need to accomplish it using the camera tool so the snapshot is the exact selection everytime. Is the excel snapshot temporarily saved somewhere on my computer where I can access it?

Thank you!

 

[Gary's Student]

Insert a Chart in your workbook. Place the snapshot on that chart. You can then export the Chart using VBA. See:

Export Chart as Image File | Peltier Tech Blog | Excel Charts