testing for blank

  • Thread starter Thread starter ChuckM
  • Start date Start date
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
 
cells(rows.count,activecell.column).end(xlup).row
or
cells(rows.count,"a").end(xlup).row
 
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
 
Back
Top