Forum Discussion
Screenshot in Excel
Hi,
I'm wondering if anyone is able to help, and if my query is at all possible.
I'm looking to insert a screenshot of Cells B2:P33 from a sheet called 'Progress' into another sheet called APR. Would this be a Macro, if so, how would I create this?
Thanks in advance,
Lewis.
4 Replies
Also, with Link:=True, the picture appears to update when you make changes to the Progress tab for those cells, so you may not need to re-copy/paste. Or, you could set it to False so it doesn't update.
- Alt+F11 to open the visual basic editor.
Click View/Project Explorer (if the project explorer window is not already visible).
Select your workbook.
Click Insert/Module.
Double click on the newly added module (in the modules folder).
Paste this code into the code window that appears.
Sub ScreenShot()
Worksheets("Progress").Range("B2:P33").Copy
With Worksheets("APR")
.Activate
.Range("A1").Select
.Pictures.Paste Link:=True
End With
Application.CutCopyMode = False
End Sub
Close the vba window.
Click Developer/Macros - select and run the Screenshot macro. If you don't have a developer tab, click File/Options/Customize Ribbon and check the developer tab box.
