WRITE IF CELL IS EMPTY EXCEL

Good afternoon!
Is there any way to find the last blank line?
I used the method below, but as there are many lines in the report, it takes a relatively long time to execute the robot.
the idea is that this report will grow with each new execution of the robot.

thank you!!

@danielle.freitas Good Noon.

I will suggest not to write on each cell, rather write on mapped column.
For Ex. If column a has a Header called ‘ColumnA’

use
row(“ColumnA”)= "Desire value "

and when you come out of for each row
use write range