Get first empty row in excel regardless of other empty rows

Hi All,

I am trying to get the next empty row number or cell in excel regardless of if there are other empty/non-empty cells after. Attached is a snapshot of the file, I am trying to get row 5.
Thank you
Screenshot 2020-11-03 211754

@Olaoluwa_Ogunwa

You can use For Each Row and in properties declare a variable for index

Now inside For Each Row place a IF condition give condition as below
row(“Name”).ToString = " "

Then
Declare a Variable as below
RowCount = cint(index+1).ToString
If you don’t want to continue further then place a break

Hope this helps you

Thanks

@Olaoluwa_Ogunwa
find starter help here:
GetIndex_RowsWithBlanks_AllCols.xaml (6.8 KB)

getting the first index can be done by accessing the first element from arrBlankIndex
e.g. arrBlankIndex(0), just check if it is not empty/null

Thank you, this worked!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.