title: VBA How to keep cell format before pasting data / Copy only Value
body: <p>I have a code that copies the data selected by me, but I would like to keep the cell format in the otuput file (zeszyt 3) as it was before pasting. I mean copy only Value without formats.</p>
  <pre><code>Set wb = Workbooks.Open(strPath, False, True)
  
  wb.Sheets(&quot;vintage_agr&quot;).Columns(&quot;A:C&quot;).Copy Destination:=wbMe.Sheets(&quot;input_4&quot;).Range(&quot;A1&quot;)
  wb.Sheets(&quot;vintage_agr&quot;).Columns(&quot;H&quot;).Copy Destination:=wbMe.Sheets(&quot;input_4&quot;).Range(&quot;D1&quot;)
  wb.Sheets(&quot;analityka_id-tabele&quot;).Range(&quot;E68:G71&quot;).Copy Destination:=wbMe.Sheets(&quot;strona 3&quot;).Range(&quot;E16&quot;)
  wb.Sheets(&quot;analityka_id-tabele&quot;).Range(&quot;E72:G72&quot;).Copy Destination:=wbMe.Sheets(&quot;strona 3&quot;).Range(&quot;E15&quot;)
  
  
  wb.Close False
  Set wb = Nothing
  
  Beep
  
  MsgBox &quot;Mamy to&quot;
  End Sub
  </code></pre>