View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Helmut Helmut is offline
external usenet poster
 
Posts: 111
Default 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