VBA to Copy and Past from One Sheet to Another

[rbell22]

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

[mancubus]

please use code tags when posting your code here.

the code you have posted should work.
click on the Picture and see what shape name is displayed in the address bar.