With data in Range a1:a9 of sheet1

Why in the Immediate window when I enter:

lrow = activesheet.cells(Rows.Count, 1).end(xlUp).row
or
lrow = activesheet.cells(Rows.Count, 1).end(xlUp)

Why do I get this error Application-defined or Object-defined error?

TIA,

Jim