first empty value

  • Thread starter Thread starter Karol_tom
  • Start date Start date
K

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 ?
 
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
 
Back
Top