Try
[vba]
Sub Loops()
Dim c As Range, Check As Boolean
Retest:
Check = False
For i = 1 To UBound(Range("Test")())
If Range("Test")(i) = "Server4" Then
Range("Test")(i).Value = "Changed"
i = i - 1
End If
MsgBox Range("Test")(i)
Next
End Sub
[/vba]
Try
[vba]
Sub Loops()
Dim c As Range, Check As Boolean
Retest:
Check = False
For i = 1 To UBound(Range("Test")())
If Range("Test")(i) = "Server4" Then
Range("Test")(i).Value = "Changed"
i = i - 1
End If
MsgBox Range("Test")(i)
Next
End Sub
[/vba]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'