Ot_Gu
asked on
I need help with a simple excel vba loop
Hello All,
Why doesn't this stop in cell A15?
Any help appreciated!
Thanks.
Why doesn't this stop in cell A15?
Any help appreciated!
Thanks.
Sub StopatFifteen()
Dim aktKolli As Long
Dim kolliAntal As Long
kolliAntal = 15
aktKolli = 0
Do While aktKolli < kolliAntal
For Each cell In ActiveSheet.Range("A1:A50")
aktKolli = aktKolli + 1
cell.Value = aktKolli
Next cell
Loop
End SubASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That is what I wanted. Thanks you very much.
Because your loop condition is outside your For loop, so the for loop does all 50 cells before checking for the next value.