Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use a Range in a Loop
I was wondering how you can use a range for a loop start and end positions.
Give a range B3:B25 I wouldlike to loop through each cell and if there exists a value (any number including zero) then replace the value with the associated formula ... in this case if B3, B17 and B23 were numbers then B3 becomes =sum(C3:H3) B17 becomes =sum(C17:H17) B23 becomes =sum(C23:H23) Also can variables be used as cell references dfrank = C17 B17 becomes =sum(dfrank:H17) thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range Loop | Excel Programming | |||
Add a Range to an existing Range in a loop? | Excel Programming | |||
Loop through a range | Excel Programming | |||
loop in range | Excel Programming | |||
Loop in a Range | Excel Programming |