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
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
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!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.