VBA Loops

[Chris]

Im trying to create a loop statement that moves onto the next cell once
the loop has finished and then continues with the loop, and so on. I
need help

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **

 

[JulieD]

Hi Chris

something along the lines of

Sub testloop()
For Each cell In Range("A1:A10")
If UCase(cell.Value) <> "OK" Then
MsgBox cell.Address & " - not ok"
End If
Next
End Sub

Cheers
JuieD