title: Excel Vba Copy Picture to new sheet
body: <p>i have below vba codes copy existing worksheet data to new worksheet, it's working fine, but it won't copy pictures file (eg.jpg) in worksheet, how can i  copy picture file as well? Thank you.</p>
  
  <pre><code>  Set source2 = Worksheets("today").Range("A5:l68")
  
         Sheets.Add After:=Sheets(Sheets.Count)
      Set dest2 = ActiveWorkbook
      Source2.Copy
        With dest2.Sheets(2)
         .Cells(1).PasteSpecial Paste:=8
         .Cells(1).PasteSpecial Paste:=xlPasteValues
         .Cells(1).PasteSpecial Paste:=xlPasteFormats
         .Cells(1).Select
  
      Application.CutCopyMode = False
  
  End With
  </code></pre>