Below is an example of looping through the rows in Excel and stopping when there is an empty cell.
' This code was borrowed from http://www.viiweb.com and is free to use without
' warranties or guarantees.
While (ActiveCell.Value <> "")
Tested Platform: Excel 2010