Problem with looping

Re: "This code does the trick row by row"

Maybe explain what you want to do in a concise way.
When volunteers give you a solution, it might be different from what you have. At that time you can ask for a looping solution.

So...Wanting to clear the row if Col X contains "6. Shipped"
Or only cells for specific columns i.e. B | D | K | X & Y

Please upload a small sample showing before | after result

To stay close with what you showed.

Please Login or Register  to view this content.

There is better ways of solving your problem, that's why my question im the previous post to make sure I understand your requirement properly.

Non looping option...

Please Login or Register  to view this content.

Normally it is better to use the "lr" statement for last used cell in a column. That way you don't have to hard code a value in your code.
There are a lot of different ways to calculate "lr". This is just one of the possibilities.

As stated in my last line of Post #5 about better ways, you should try "Master Magician" Sintek's suggestion also.

Master Magician" Sintek'

Far from it...Just like you...I too just learn daily from the Masters here...
Sometimes I don't even know what I'm doing...As my signature says...
One day one problem at a time...

All in good fun Sintek.
At least we understand that there is no limit to expanding our knowledge and horizon.

The reason I said that though is because you,ve suggested some fantastic, in my mind anyway, solutions in threads I followed.
Keep up the good work.

@ jolivanes...
Fun to be able to contribute & learn at the same time...
Tx...Happy Coding...