If Not IsEmpty()

[nikko50]

So I want to check if IsEmpty is truly empty within the loop. I tried the below but get a compile error. What did I do wrong?


Do While Not IsEmpty(Cells(i, 1))

If Not IsEmpty(Cells(i, 1) Then

'DO STUFF

End If


Loop

 

[shg]

    Do Until IsEmpty(Cells(i, 1).Value)
        ' ...
    Loop

 

[nikko50]

I have code within the Do Loop that I want to not execute if the loop has reached it's final loop. How can I do this

 

[shg]

The code inside the loop won't execute if the cell is empty.