How to take screenshot of certain range?

[sooshil]

Hi

I want to take screenshot of a range and expect a prompt to save it.
The range is not always same.
The maximum range is same... means there wont be more than 11 rows and 10 columns. But, I only want to take screenshot of the range having data. That is less than or equal to 11 rows. Number of columns is always 10.
I just want to click a button and it takes screenshot of the range and asks me to save it.

It it really possible?

 

[James006]

Hi,

You should take a look at the Camera tool ...:wink:

see link : https://excelchamps.com/blog/camera-tool/

Hope this will help