Get ComLastRow of hoSheet to iRows

will give you the no of the last row in the sheet.

/Bengt