Find Next Empty Cell doesn't work

[JuFigueiredo]

Hi, I have been having a problem writing data from a collection to a worksheet. I have an woorkbook that needs to be updated constantly and when I use the action of finding the last empty cell it takes a tandom cell in the middle of the worksheet.

 

[Muksith]

first select the row you want and apply the action.