Support Portal

for ProcessRobot and WinAutomation

Start a new topic

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.

Login or Signup to post a comment