Hello,

you can use the method UsedRange on a worksheet object to find the last used cell in a worksheet object. This way, you don't need to iterate over all 64K rows (or more with Excel 2007) which should save much time.

But I don't know a better way to find out which lines or columns are empty than an iteration.