Peter Chan
asked on
Problem to skip loop
Hi,
I want to skip the loop below, per relevant conditions are matched
I want to skip the loop below, per relevant conditions are matched
Do While True
...
If Trim(Worksheets(List0).Cells(RowID, 8).Value) <> "" And InStr(User_List, ";" & Trim(Worksheets(List0).Cells(RowID, 8).Value)) = 0 Then Continue Do
End If
but I get 'Syntax Error' due to 'Continue Do'. What to adjust?
If you want to leave the Do loop then use Exit Do
ASKER
No, I only want to skip one iteration, and not to leave the whole loop.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Looks like you are not fully satisfied with the answer.
do while condition
if certain condition then
exit do
endif
loop