AutoFill down X number of rows.

[Paul987]

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

Any Help would be great. TIA
Paul

[JE McGimpsey]

One way:


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

In article <Paul987.26s1sc_1145896507.4996@excelforum-nospam.com>,
Paul987 <Paul987.26s1sc_1145896507.4996@excelforum-nospam.com> 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

[Paul987]

I only needed one way. That worked well. Thanks
Paul