I suggest using worksheet.usedrange.columns.count and usedrange.rows.count
You can then use worksheet.cells to refer to it.
Geoff
"Hawk" wrote in message
...
How do I find the last non-empty cell on a worksheet?