Last Row in excel.application

[kcvinu]

Hi all,

Look this code.

Local $iLastRow = $xlSheet.UsedRange.Rows($xlSheet.UsedRange.Rows.Count).Row
Local $iLastRow2 = $xlSheet.UsedRange.Rows.Count

Both are giving same results. Among these two methods, which is safer ?

Edit - @Moderator, which is font used in code area ?. It is very nice to see autoit code in this font. Especially it's thickness.

Edited October 12, 2015 by kcvinu

[water]

I would use code line #2. It is easier to understand when you look at your code after a few months.
But it depends on which result you want to get. Please check the wiki for my Excel Range page and see how UsedRange works.

[kcvinu]

@water , Thank you.

 

[water]