Deleting Specific Rows

My data looks as follows:

B1 Heading
B2 717/123
B3 737/45
B4 738/78
B5 745/453
B6
...

I have to search for the characters before '/' and change their values. I have got this part working (see code).
For the values that I don't define in my code, I want to delete that entire row, or if the column is blank, I want to delete that entire row as well. When I tried doing this (Case Else), it does not work

Please Login or Register  to view this content.

Anything I am doing wrong? or if you have a better way of doing this, please let me know

Rather than retrieving cells from the range collection, use a loop, traversing BACKWARDS.

Please Login or Register  to view this content.

Originally Posted by shg

Rather than retrieving cells from the range collection, use a loop, traversing BACKWARDS.

Is there an advantage in going backwards?

Yes. Think about what row you're referencing when you delete rows in some iterations, and increment a row index on every iteration.