Excel: Find first free cell on column
Is there a way to find the first free cell on a given column (see screenshot) without having to first loop every cell on this column?
"find first free row on column" doesn't work in this instance..
Hope this makes sense.
No, I don't think there is.
An operation like looping through a list an then exiting when there is no content should be very very fast.
Why is it a problem? :]
I generally need my bot to start at the row where this cell is empty (this is where the status gets written, like "done" for example. When having a list of multiple thousand rows this gets quite slow with a loop.
So having to wait 20-60 seconds each time is kind of annoying..
I thought maybe there was kind of a simple solution that I'm missing.