Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO range find last row
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO range find last row
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to find value and then copy associated range | Excel Discussion (Misc queries) | |||
Macro to find a range that varies. | Excel Programming | |||
macro to find out the last cell in a range | Excel Programming | |||
Using a Macro to find a value in a range and activate it | Excel Programming | |||
Macro to find the 6th occurrence and move range | Excel Programming |