title: Copying cells without the fomulas, but with format VBA
body: <p>this macro copies the cells in another Workbook. How can I make it copy only the format and the values without the formulas.</p>
  
  <pre><code>    With Worksheets("Analysis")                             
              Range("A1:J35").copy                                        
  
              Windows("2016-Backtesting-Aggregation_EquityNEU.xlsx").Activate                                                             
              Sheets.Add After:=Sheets(Sheets.Count)                      
              Range("A1").PasteSpecial _                                  
              Operation:=xlPasteSpecialOperationAdd                       ´
   End With
  </code></pre>