rbell22
03-06-2017, 07:08 AM
Hello,
I thought this would be an easy one, but I cannot quite get it right. I need to copy a jpg titled "Conditions" from Sheet3, and paste "Conditions" into cell (or in the area of) H1 of Sheet5.
This is what I have...
Sub CopyPict()
Worksheets("Sheet3").Shapes("Conditions").Copy
Worksheets("Sheet5").Range("H1").PasteSpecial
End Sub
Thank you all very much for your help.
Rob
I thought this would be an easy one, but I cannot quite get it right. I need to copy a jpg titled "Conditions" from Sheet3, and paste "Conditions" into cell (or in the area of) H1 of Sheet5.
This is what I have...
Sub CopyPict()
Worksheets("Sheet3").Shapes("Conditions").Copy
Worksheets("Sheet5").Range("H1").PasteSpecial
End Sub
Thank you all very much for your help.
Rob