title: Pasting Values in Excel not Formulas from a Macro
body: <p>I currently have a macro that copies data from one sheet and archives it in another sheet. The issue that I have is that it is copying and pasting the formulas and it need to copy and paste values only. </p>
  
  <pre><code>Sub Archive_Execution()
  
  Dim mainworkbook As Workbook
  Set mainworkbook = ActiveWorkbook
  Dim rangeName
  Dim strDataRange As Range
  Dim keyRange As Range
  
  rangeName = "Archive_Execution"
  Application.Goto Reference:=rangeName
  Selection.Copy
  Sheets("Archive Execution").Activate
  Range("A" &amp; Rows.Count).End(xlUp).Offset(1).Select
  mainworkbook.Sheets("Archive Execution").Paste
  
  Sheets("Archive Execution").Activate
  Set strDataRange = Range("A2:AA1000000")
  Set keyRange = Range("D1")
  strDataRange.Sort Key1:=keyRange, Order1:=xlAscending
  
  End Sub
  </code></pre>
  
  <p>Any help would be greatly appreciated on tweaking my code so that only values are pasted not formulas</p>