Find first empty row

[Ken G]

I need to find the row number of the first empty row in a spreadsheet. I've seen some solutions for finding the last value in a column, but I need the first empty row number

Thanks
Ken G.

 

[Ken G]

OK I've done this using COUNTA(A$:A$) - but now I need to use this value in a range - see separate post.

 

[Vasant Nanavati]

Do you mean the first *completely* empty row?

A VBA solution:

With ActiveSheet.UsedRange
MsgBox .Rows(.Rows.Count).Row + 1
End With

This assumes that you ignore empty rows at the top of the sheet, before your
data begins.

--

Vasant

I need to find the row number of the first empty row in a spreadsheet.

I've seen some solutions for finding the last value in a column, but I need
the first empty row number.

 

[Ken G]

Yes, but I allowed for rows above the data

----- Vasant Nanavati wrote: ----

Do you mean the first *completely* empty row

A VBA solution

With ActiveSheet.UsedRang
MsgBox .Rows(.Rows.Count).Row +
End Wit

This assumes that you ignore empty rows at the top of the sheet, before you
data begins

--

Vasan

I need to find the row number of the first empty row in a spreadsheet

I've seen some solutions for finding the last value in a column, but I nee
the first empty row number