looping not worked for consecutive data

Hi!

The function that I have created was to delete entire rows if some cell contain text.

Please Login or Register  to view this content.

But, it seems not worked if I have more than 1 consecutive text data (on the next row).
You can try it in the following attachment.

Can anyone help me solving this problem?

Thanks in advance!

When you're deleting things, you have to work backwards. If you think about it, youll understand why.

So -- either of these:

Please Login or Register  to view this content.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save