How do you put a screen shot command into a macro?
i.e. I need my macro to do a screen shot of the active sheet.
I tried it by recording a macro but it doesn't put anything into the code after the "Print Scrn" keyboard button is hit.
How do you put a screen shot command into a macro?
i.e. I need my macro to do a screen shot of the active sheet.
I tried it by recording a macro but it doesn't put anything into the code after the "Print Scrn" keyboard button is hit.
I want to choose the area to copy, thus I use the following:
Sub CopyRangeAsPic()
sel = InputBox("Enter the Range in 'A1 : D5' Format", "Enter the Cell Range You Want to Copy")
ActiveSheet.Range("" & sel & "").copypicture xlScreen, xlPicture
End Sub
HTH, Manfred
Re: screen shot command
There is another alternate method to take print screen and save it as an image file.
http://officetricks.com/print-screen-s…utomate-in-vba/
The code in this topic automates the key strokes Alt Tab, Print Screen and Save as Image file to a specific path.
Don’t have an account yet? Register yourself now and be a part of our community!