testing for blank

C

ChuckM

I'm searching down a column and would like to find the last row in the
list. The column contains integers and the rows after the last row are
all blank.
thanks
chuck
 
D

Don Guillett

cells(rows.count,activecell.column).end(xlup).row
or
cells(rows.count,"a").end(xlup).row
 
S

Steve Hieb

This will return the row number for the first empty cell found in
Column B after row 3 on the first sheet. In this example "B3" is used
to show how to ignore blanks in B1 and B2 in case you have something
like this.

MsgBox Sheet1.Range("B3:B65536").Find("").Row

Regards,
Steve Hieb
 
Top