Any reason you didn't use

loExcelSheet.UsedRange.Rows.Count

?

>
>I altered what you pointed out with what Jon gave me to get what I needed.
>
>

loExcelSheet.Range("A1", loExcelSheet.Range("A1").SpecialCells(11)).Select()