mdmackillop I just tested your suggestion above and it does not work. Even if I change c inside the loop, let's say:
[VBA]
Sub Loops()
Dim c As Range, Check As Boolean
Retest:
Check = False
For Each c In Range("Test")
If c = 5 Then
c.Value = 4
Check = True
Exit For
End If
Next
If Check = True Then Goto Retest
End Sub
[/VBA]
If Test is a range of numbers from 1 to 5, and I change the value of c inside the loop, it will still go to the next c in range. Example:
if c=3 and I change it inside the loop to 1, next it will go to 4, not to 2.
When I try the same inside:
for i=1 to 10 loop, like someone suggested above , that will work, but I need to do it inside the range