Hello
I am trying to determine how many blank rows until the next non blank row in column A (ID).

In the table below, I would like to do something like a For Next Loop and capture the total blank rows after the first ID.

So: ID 12345 = 2 empty/blank rows.

ID Value
12345
24566
333222