first empty value

[Karol_tom]

Hi,
I use this code:

n = Range("B1").End(xlDown).Row + 1
Cells(n, 2).Select


to select first empty cell in column B...but I discover that it's not
perfect
if there are some break (one empty cell between cells with values) it will
choose it - there's some another function ?

 

[Gord Dibben]

To exclude interior blanks, go to bottom of sheet and work up.

Sub findbottom()
ActiveSheet.Cells(Rows.Count, 2).End(xlUp) _
.Offset(1, 0).Select
End Sub


Gord Dibben MS Excel MVP