View original (French)

Copy an image in one sheet and paste it into another in VBA

Boisdurouge Posted messages 8 Status Member -  
Boisdurouge Posted messages 8 Status Member -
Hello,

As the title suggests, I simply want to copy an image found in Sheet2, regardless of its position in the sheet, and paste it into Sheet1, so that the top left corner of the image aligns with the top left corner of cell A1.
I want to point out that I have already searched for something as basic as this, but every time I look it up, I come across more complex subjects, and I am a beginner in VBA...

Thank you

2 answers

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    Hello

    Code to adapt: 
    Sub copy() ActiveSheet.Shapes("Image 1").Select ' adjust the name of the image - the one in the left bar of the formula bar Selection.Copy Windows("Workbook2").Activate ' adjust the name of the workbook Sheets("Sheet1").Select ' adjust the sheet name Range("A1").Select ActiveSheet.Paste End Sub


    Regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    0
  2. Boisdurouge Posted messages 8 Status Member
     
    Thank you :)
    0