(Solved) – VBA Backward loop in a range

(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.
https://imgshare.io/image/vba.1tPQf

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 *