How find first empty row using Select?

[Sudharsan_Ka]

@aleksandra.plichta5

You can try with Find First/Last Data Row activity in the modern design

To enable it
Go to → Activities Panel → Click on Filter → Select Show Modern.

StudioX - Find Last data row in excel file

@ayyagari.sudhakar - I was able to achieve it with out using Find Last Row/Column. Here is the xaml. FindLastRow_20.4.zip (647.3 KB) Idea is simple: I wrote the excel formula on the cell as: =LOOKUP(2,1/(B:B<>“”),ROW(B:B)) This will give the last row count. Then i added +1 and saved it to a variable. Finally wrote the output text using the variable ex: B34. Please test this and let me know.

Regards
Sudharsan