Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For each
I've assigned a Obj variable: Set oRng=C3:P84 (there are 84 elements/items)
So I then have Dim c as Range 'code For each c in oRng Next c As I step thru the code I need to perform an action when (using IF) c reaches element, say 32 -- How is this done using the For each method? I know I could assign a counter i (and do the i = i + 1 inside), but is that necessary using the For each. Thanks in advance.. Jim |