PDA

View Full Version : VBA to Copy and Past from One Sheet to Another



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

mancubus
03-06-2017, 07:42 AM
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.