(Solved) – VBA Backward loop in a range


I have little problem, which is;
I have the table below and what I want is to loop from right to left and count all the empty cells until the code meets a string. The amount of empty cells should be recorded in the column on the right.

The problem is that I couldn’t figure out how to loop backwards and move on to the next row and start from right again. I hope you guys can help me out with this.

Thank you in advance.

Leave a Reply

Your email address will not be published. Required fields are marked *