title: excel error: invalid or unqualified error
body: <pre><code>Sub Macro5()
      '
      ' Macro5 Macro
      '
      
      '
      Dim wbk As Workbook
      Application.ScreenUpdating = False
      
      Set wbk = Workbooks.Open(&quot;g:\Work\EU Personal Assignment.xlsx&quot;)
          Range(&quot;O2:R2&quot;).Select
          Range(Selection, Selection.End(xlDown)).Select
          Selection.Copy
          Windows(&quot;Dashboard_for_Roshan.xlsm&quot;).Activate
          Range(&quot;A65536&quot;).End(xlUp).Select
          ActiveSheet.Paste
          Windows(&quot;EU Personal Assignment.xlsx&quot;).Activate
          Range(&quot;A2&quot;).Select
          Range(Selection, Selection.End(xlDown)).Select
          Application.CutCopyMode = False
          Selection.Copy
      
      
          Windows(&quot;Dashboard_for_Roshan.xlsm&quot;).Activate
          Range(&quot;E65536&quot;).End(xlUp).Select
          ActiveSheet.Paste
          Windows(&quot;EU Personal Assignment.xlsx&quot;).Activate
          Range(&quot;AC2&quot;).Select
          Range(Selection, Selection.End(xlDown)).Select
          Application.CutCopyMode = False
          Selection.Copy
      
          Windows(&quot;Dashboard_for_Roshan.xlsm&quot;).Activate
          Range(&quot;F65536&quot;).End(xlUp).Select
          ActiveSheet.Paste
      
      
      
      Call .wbk.Close(False) &lt;- i get the error here 
      
      
  End Sub
  </code></pre>
  <p>Prior to the excel <code>End(xlUp)</code>, I was using</p>
  <pre><code>Cells(Cells(Rows.Count, &quot;A&quot;).End(xlUp).Row + 1, &quot;A&quot;).Select
  </code></pre>
  <p>but I was unable to paste data using this.</p>
  <p>Edit: the error was an extra <code>.</code> before .wbk
  but now it replaces the previous row data, whereas I want it to paste data below the last used row.
  any advice?</p>