title: How to copy only values in excel vba from a range?
body: <p>I'm trying to copy values from a table to a Range, in Excel using vba Macros, but I dont want the table format, only its values.  How can I achieve this?</p>
  
  <p>Here is part of the code:</p>
  
  <pre><code>    'Source range
      Set r = Sheets("Sheet1").Range("Table1")
  
      'Destination range
      Set dest = Range(.Cells(linhaAtual, 1), .Cells(linhaAtual + r.Rows.Count - 1, 5))
  
      r.Copy Destination:= dest
  </code></pre>