View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Steve Hieb Steve Hieb is offline
external usenet poster
 
Posts: 27
Default 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