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