title: Selection.Filldown
body: <p>I am trying to fill down data from lastrow of column B to I up to the last row of column J. I have tied the below code but its not working.</p>
  
  <pre><code>Sub Macro3()
      Dim lrow As Long
  
      LW = Worksheets("master log-1").Cells(Rows.Count, 10).End(xlUp).Row
      NW = Worksheets("master log-1").Cells(Rows.Count, 2).End(xlUp).Row
  
      MsgBox "Last Row: " &amp; LW
      MsgBox "Last Row: " &amp; NW
  
      Worksheets("master log-1").Range("B" &amp; NW, "I" &amp; NW).AutoFill Destination:=Range("B:I" &amp; lrow), Type:=xlFillCopy
  
  End Sub
  </code></pre>