first empty value

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 ?
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Trying to run excel vba code when cell value changes from empty to entered value. 1
VBA set thick borders around non empty cells in range 0
Find first empty cell in column 2
sum values 6
Help on Macro to hide empty rows 4
Complicated formatting 2
Select first empty row in a column 9

Top