Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Loop and autofill
Excel 2003 SR1
I have several columns with formulas in them (row 3). I recorded a macro which autofills to a specific row. Range("K1").Select Application.CutCopyMode = False Selection.AutoFill Destination:=Range("J1:J55000"), Type:=xlFillDefault Range("K1:K55000").Select It would be better (since the number of rows changes with each new file), to test on if a cell in column A = blank, stop the autofill. I've just discovered Do While ...Loop, but am not clear where it captures the formula. Do I put the formula (ex - =IF(AND(K3"0",K3<"A"),K3,N2) below the Do While Column A <"", or refer to the cell with the formula in it? TIA, CaroleO |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vba loop | Excel Discussion (Misc queries) | |||
Which loop to use | Excel Discussion (Misc queries) | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Help with a Loop | Excel Discussion (Misc queries) | |||
Help With Loop | Excel Worksheet Functions |