title: autofill down according to adjacent column
body: <p>I'm looking for VBA code that will autofill data down according to the length of an adjacent column. I know there are a few ways to go about this, but which is best?:</p>
  
  <pre><code>If LastRow &gt; Selection.Row Then
     Range("D2").AutoFill Destination:=Range("D2:D" &amp; LastRow)
  </code></pre>
  
  <p>or something like:</p>
  
  <pre><code>If Not IsEmpty(ActiveCell.Offset(0,1)) Then
     Range("D2").AutoFill Destination:=Range("D2:D" &amp; LastRow)
  </code></pre>
  
  <p>I'm pretty sure neither of these work exactly how I want it so what am I missing?</p>