MACRO range find last row

[Helmut]

Hi,
I want to write Macro which finds LAST_ROW_NUMBER and then inserts it into a
RANGE for PRINTING or SORTING
i.e. rows keep adding daily and for Sort Macro Range I need the
LAST_ROW_NUMBER
right now I do it with a DIM and INPUTbox but I want to do it without manual
interface.
thanks
Helmut

[Bob Phillips]

LastRow = Cells(Rows.Count,"A").End(xlUp).Row

assuming you are looking in column A

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Helmut" <Helmut@discussions.microsoft.com> wrote in message
news:08E25E1E-B66B-4A7A-A5F4-6022AD042FFE@microsoft.com...
> Hi,
> I want to write Macro which finds LAST_ROW_NUMBER and then inserts it into
a
> RANGE for PRINTING or SORTING
> i.e. rows keep adding daily and for Sort Macro Range I need the
> LAST_ROW_NUMBER
> right now I do it with a DIM and INPUTbox but I want to do it without
manual
> interface.
> thanks
> Helmut