Hello,
I am trying to copy cells from one tab to another as a picture. It copies as a picture, but won't resize. Code gets an error after pictures.paste
Thanks in advance.
I am trying to copy cells from one tab to another as a picture. It copies as a picture, but won't resize. Code gets an error after pictures.paste
Thanks in advance.
Code:
Application.CutCopyMode = False
Worksheets("Orig-Plant").Activate
ActiveSheet.Range("B2:N67").Copy
With Worksheets("Report")
.Activate
.Range("B47").Select
.Pictures.Paste
.Selection.ShapeRange.LockAspectRatio = msoFalse
.Selection.ShapeRange.Height = 328.32
.Selection.ShapeRange.Width = 747.36
End With