شمارش ردیف ها در اکسل

Returns a Range object that represents the cell at the end of the region that contains the source range. Equivalent to pressing END+UP ARROW, END+DOWN ARROW, END+LEFT ARROW, or END+RIGHT ARROW. Read-only Range object.

Syntax

(expression.End (Direction

lngLastRow = Cells(Rows.Count, 1).End(xlUp).Row