| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| concatenate with a varying range of cells | Excel Worksheet Functions | |||
| Using Varying Range Size in Macro | Excel Programming | |||
| For Each Loop w/ a range | Excel Programming | |||
| sumif range of varying size | Excel Worksheet Functions | |||
| Loop in a Range | Excel Programming | |||
Threaded Mode
