testing for blank
 

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

testing for blank
 

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

--
Don Guillett
SalesAid Software

"ChuckM" wrote in message
m...
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

testing for blank
 

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