title: Excel VBA Runtime Error 1004 - "Autofill Method of Range Class Failed”
body: <p>Okay! So! I have one spreadsheet, but I have to save a copy, remove data, and turn it into a template-type situation which other people can then fill out. 
  This spreadsheet has five macros - four which do a vlookup, and the fifth which triggers the other four. I'm assuming this is definitely not the best way to do this.</p>
  
  <p>Anyways, it was working pretty great on the original spreadsheet, but mysteriously, when I saved a copy and made a few changes (eg, removed the data, renamed a couple unrelated tabs), the macros no longer work - instead, I get this super fun error: </p>
  
  <blockquote>
    <p>Run-time error '1004':
    AutoFill method of Range class failed</p>
  </blockquote>
  
  <p>Hitting debug points a snazzy little arrow at the fourth line that begins with Range(G2). </p>
  
  <pre><code>Sub fillpronoun()
   Dim LR As Integer
   LR = Range("H" &amp; Rows.Count).End(xlUp).Row
   Range("G2").AutoFill Destination:=Range("G2:G" &amp; LR), Type:=xlFillDefault
  End Sub
  
  Sub fillfullname()
   Dim LR As Integer
   LR = Range("H" &amp; Rows.Count).End(xlUp).Row
   Range("I2").AutoFill Destination:=Range("I2:I" &amp; LR), Type:=xlFillDefault
  End Sub
  
  Sub filloffice()
   Dim LR As Integer
   LR = Range("H" &amp; Rows.Count).End(xlUp).Row
   Range("J2").AutoFill Destination:=Range("J2:J" &amp; LR), Type:=xlFillDefault
  End Sub
  
  Sub CA()
  Dim LR As Integer
   LR = Range("H" &amp; Rows.Count).End(xlUp).Row
   Range("M2").AutoFill Destination:=Range("M2:M" &amp; LR), Type:=xlFillDefault
  End Sub
  
  Sub runall()
  fillpronoun
  fillfullname
  filloffice
  CA
  End Sub
  </code></pre>
  
  <p>Does anyone have any ideas what I might be doing wrong? I'm sure I'm overlooking something really comically simple! Any help would be greatly appreciated. </p>