AutoFill down X number of rows.
 

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


--
Paul987
------------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=535596

AutoFill down X number of rows.
 

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

AutoFill down X number of rows.
 

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


--
Paul987
------------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=535596