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
 
You must log in or register to reply here.

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

Column number of last column that returns value ignore formulas 8
Check a range to see if a value exists in it 5
Print variable number of rows of spreadsheet 1
Eliminate blanks while copy row and transpose 11
Multiple SUM's in a column 15
Paste in column B using Last row of either column B, C or D. 10
Find a value in a sheet and replace it with another value if it matches 8
Selecting Range Based on Cell Content then Copy/Paste to New Sheet,Looping 2

Back
Top