Making a Screenshot and copying to a new sheet in excel

[Nici BP]

Dear community,


recently, I am trying to make a screenshot of my Excel sheet. I open Excel (Create instance -> open workbook -> ...). I would like to take a screenshot of my current sheet, then create a new sheet and insert the screenshot into this new sheet.

Do you have any idea how I can implement this?

Thank you so much!

 

[drubiano]

Well, first you need a object for taking a screenshot.

Then you can either just paste it into a cell (I have tried this, but it isn’t beautiful), or spy Excel as an application and navigate Insert>Insert picture.