title: Run-time error 1004 Paste special error. What is another way of writing it
body: <pre><code>Workbooks.Open Filename:=&quot;W:\MANUFACTURING\lppo\Emerging Markets\98-CMMS Forecast Reports\S2 - Ocean Containers Shipped\Data Files\UtilizationByLocation.xlsx&quot;
  
  
  ActiveWorkbook.Names.Add Name:=&quot;RecordCount&quot;, RefersToR1C1:=&quot;=Q_50_UtilizationByLocation_01_O!R1C100&quot;
  
  Range(&quot;CV1&quot;).Select
  ActiveCell.FormulaR1C1 = &quot;=COUNTA(C[-99])&quot;
  
  RecordCount = Range(&quot;RecordCount&quot;)
  
  
  
  
  Range(&quot;A2:G&quot; &amp; RecordCount).Select
  
  'Range(Selection, Selection.End(xlDown)).Select
  
  Selection.Copy
  
  Windows(&quot;TC Containers Shipped Report Template.xlsm&quot;).Activate
        
  Sheets(&quot;Utilization By Location&quot;).Select
  
  Range(&quot;A2&quot;).Select
  
  Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
      False, Transpose:=False
  </code></pre>
  <p>I am getting an error at  Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
  False, Transpose:=False</p>