One way:


With Selection
.AutoFill Destination:=.Resize(Cells(4, 12).Value, 1), _
Type:=xlFillDefault
End With

In article ,
Paul987 wrote:

Hello. I am trying to autofill a formula down a certain number of rows.
The number is located in cell L4. I can't seem to figure out the
syntax for this. This is what I have, but it does not work.

Selection.AutoFill Destination:=Range("A1:A" + Cells(4, 12)),
Type:=xlFillDefault