title: VBA Paste Data After Last Row Issue
body: <p>I am compiling data from multiple worksheets to place on one consolidated sheet.  The first sheet is easy because I can paste the entire sheet however after that it becomes tricky as I only need from A5-H### as I no longer need the header.  I then need to paste this information at the bottom of the previous paste.  I am getting a Range of Object "_Global" failed for the 'Range(lastRow).Select'.  The issue is when I look at it in the debugger it is coming up with the correct row number.  What am I doing wrong? </p>
  
  <pre><code>Sheets(1).Select
  Cells.Select
  Application.CutCopyMode = False
  Selection.Copy
  Sheets("Consolidation Sheet").Select
  Range("A1").Select
  ActiveSheet.Paste
  Sheets(2).Select
  Range("A5:A925").Select
  Range(Selection, Selection.End(xlToRight)).Select
  Application.CutCopyMode = False
  Selection.Copy
  Sheets("Consolidation Sheet").Select
  Range("A5").Select
  lastRow = ActiveSheet.Cells(Rows.Count, "E").End(xlUp).Row + 1
  Range(lastRow).Select
  ActiveSheet.Paste
  </code></pre>