View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul987
 
Posts: n/a
Default 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