Counting should stop at blank cell

Good day friends,


The code down below counts all cells from column A2 to I11.

The problem; the code should stop counting if there is a blanc cell in a column and go to the next column to countinue .

My query; how should the code be modified so it will stop counting if there is a blanc cell.


Thank you for any help offered!

Greetings from Roberto, The Netherlands

Please Login or Register  to view this content.

Not immediately clear if there are certain guarantees regards data types in each column nor if there is always a blank, what the content of row 12 is etc... but a fairly robust approach would be

Please Login or Register  to view this content.

10^10 is used to generate a big number, a bigger number than would otherwise be found in the lookup_vector
(which in essence ensures you return the last number found in the lookup_vector [or associated value from result_vector if in use - not so here])