Excel VBA Skip Do while loop

Question

How to use continue statement to skip the loop for next iteration. So that if condition fails the loop must go for next iteration

The code goes as follows:

Do While i<50 
    If IsEmpty(Cells(EndRow, 25)) = False Then
        Continue Do 
    Else 
        Cells(EndRow, 25).Interior.ColorIndex = 37 
    i = i+1 
LOOP

user3598756 · Accepted Answer · 2016-11-18 06:26:24Z

1

maybe you're after this

Do While i < 50
    If IsEmpty(Cells(EndRow, 25)) Then Cells(EndRow, 25).Interior.ColorIndex = 37
    i = i + 1
Loop

answered Nov 18, 2016 at 6:26

user3598756

29.5k4 gold badges20 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel VBA Skip Do while loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related