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