View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
McManCSU McManCSU is offline
external usenet poster
 
Posts: 1
Default Range varying in for loop


Basically I want to be able do something like this:

Range("A&initialrow : B&initialrow").Select
and
Selection.AutoFill Destination:=Range("A&initialrow-1 : B&x"),
Type:=xlFillCopy

where they are both in a for loop and 'x' is the incremental value, and
initialvalue is some constant. Im sure I just have sytax wrong, but I
cant find anything like it. Thanks!


--
McManCSU
------------------------------------------------------------------------
McManCSU's Profile: http://www.excelforum.com/member.php...o&userid=24379
View this thread: http://www.excelforum.com/showthread...hreadid=379708