Get last row number in an Excel worksheet

[GraeagleBill]

I tried the following line of code but Access compiler doesn't know about the xlUp in the End part. The intent is to find the last non-blank cell in column "L".

xlsApp.Worksheets("Membership").Cells(Rows.Count, "L").End(xlUp).Row

[GraeagleBill]

Found the list of Excel constants in solving this problem. I wonder now in hindsight if adding an Excel library reference would have cleared this up........... anyone know about such things.

Solution:

xlsApp.Worksheets("Membership").Cells(xlsApp.Rows.Count, "L").End(-4162).Row