Support Portal

for ProcessRobot and WinAutomation

Start a new topic

Excel: Find first free cell on column

Hi,


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?


image



"find first free row on column" doesn't work in this instance..


Hope this makes sense.


Thanks


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