Get first empty row in excel regardless of other empty rows

[Olaoluwa_Ogunwa]

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

[Srini84 (Srinivas)]

@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

[ppr (Peter)]

@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

[Olaoluwa_Ogunwa]

Thank you, this worked!