title: vba copy certain range and paste as picture
body: <p>Now I can copy the whole borders from Sheet1 to Sheet2 but my problem is I can't copy the specific range like last 10 columns value with the header. For example, when input new value at O column it will just copy and paste the from F to O with the headers.</p>
  
  <pre><code>Worksheets("sheet1").Select
  Set startcell = Range("B2")
  startcell.CurrentRegion.CopyPicture xlScreen, xlBitmap
  Sheets("Sheet2").Select
  Range("B2").Select
  ActiveSheet.Paste
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/acMC5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/acMC5.png" alt="example of image"></a></p>