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
Microsoft ExcelMicrosoft OfficeVisual Basic ClassicVBAVB Script
Last Comment
Saqib Husain
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Looks like you are not fully satisfied with the answer.
do while condition
if certain condition then
exit do
endif
loop