Hello,

_Example_

RANGE(\"A1:H44\").SORT KEY1:=RANGE(\"B2\"), ORDER1:=XLASCENDING,
HEADER:= _
XLGUESS, ORDERCUSTOM:=1, MATCHCASE:=FALSE,
ORIENTATION:=XLTOPTOBOTTOM, _
DATAOPTION1:=XLSORTNORMAL


My problem ; the last cell of this selection (H44) is increasing every
day (H45, H46 ...).

How can I calculate automatically the last cell ?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/