Hi could you please help me I’m copying a picture image from one worksheet to another via a macro. When I do it manually it works fine but when I rum my code the picture image is not there.
My code is as follows
'Sheets("Sheet3").Select
'ActiveSheet.Shapes("Picture 1").Select
'Selection.Copy
'Worksheets(1).Activate
'Range("A1").Select
'ActiveSheet.Paste
'Range("D9").Select
'Sheets("Sheet3").Select
'Range("B16").Select
'Sheets("Sheet3").Select
'ActiveWindow.SelectedSheets.Delete
'Range("A11").Select
'Worksheets(1).Activate
Swifey
My code is as follows
'Sheets("Sheet3").Select
'ActiveSheet.Shapes("Picture 1").Select
'Selection.Copy
'Worksheets(1).Activate
'Range("A1").Select
'ActiveSheet.Paste
'Range("D9").Select
'Sheets("Sheet3").Select
'Range("B16").Select
'Sheets("Sheet3").Select
'ActiveWindow.SelectedSheets.Delete
'Range("A11").Select
'Worksheets(1).Activate
Swifey