title: Copy-paste picture with random range in VBA and Excel
body: <p>Here is my code. I wanted to paste the picture in specific range, i tried different codes but failed. I want it to the top left, Or started in "A1".</p>
  
  <pre><code>         Sub CommandButton2_Click()
  
           ThisWorkbook.Sheets(3).Activate
           ThisWorkbook.Sheets(3).Range("B5:G32").Select
           Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap
           Sheet10.Pictures.Paste.Select
  
           ThisWorkbook.Sheets(1).Activate
  
           End Sub
  </code></pre>