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
|