Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#REF! errors due to number of rows | New Users to Excel | |||
Insert a number of rows based on a value in a cell on active row | Excel Worksheet Functions | |||
Counting the number of rows | Excel Worksheet Functions | |||
Is there a limit to the number of rows that can be filtered | Excel Worksheet Functions | |||
Dynamic number of ROWS | Excel Worksheet Functions |