title: Last row issues
body: <p>I'm having some issues with last row expression and autofill. I'm not sure what I'm missing here as it looks correct but it doesn't seem to be starting the vlookup in the proper cell (N2, it starts it in N1) and it won't autofill to the last row of M. Any push in the right direction would be greatly appreciated. I'm thinking it's something small I'm overlooking. </p>
  
  <pre><code> Sub Nightly()
   '
   ' Nightly Macro
   '
  Dim PackSpec As Workbook
  Dim FullBook As Workbook
  Dim DebFile As Workbook
  Dim lrow As Long
  
  lrow = Cells(Rows.Count, 1).End(xlUp).Row
  
  
  'Open the nightly pack spec file, cut and insert the year row into column D
  Set PackSpec = Workbooks.Open("S:\Accounting\Apps\Packspec\CIDExport\Archive\" &amp; Year(Date) &amp; "\" &amp; Month(Date) &amp; "\" &amp; Day(Date) - 1 &amp; "\*.csv")
  Columns("A:A").Select
  Selection.Cut
  Columns("D:D").Select
  Selection.Insert Shift:=xlToRight
  Range("A2").Select
  
  'Open Fullbook master and insert columns after N then VLookup between Pack Spec and Fullbook
  Set FullBook = Workbooks.Open("S:\Corporate\Groups\Comosoft\Downloads\FullBook\fullbook_Master.csv")
  Columns("N:U").Select
  Selection.Insert Shift:=xlToRight
  Range("N2").Select
  
  'Actvate Fullbook and enter Vlookup for dates
  Windows("fullbook_Master.csv").Activate
  With ActiveSheet.Range("N2")
  .FormulaR1C1 = "=VLOOKUP(RC[-1],'[15.50.1.CID.csv]15.50.1.CID'!C[-13]:C[-11],3,0)"
  .AutoFill Destination:=Range("N2:N" &amp; lrow) 'issue not autofilling to end
  Windows("fullBook_Master.csv").Activate
  End With
  
   End Sub
  </code></pre>