=WORKSHEETFUNCTION.MIN(RANGE("B4:B8"))
=WORKSHEETFUNCTION.MAX(RANGE("B4:B8"))

Ed Wrote:
What are the codes to obtain the min and the max in a rage say
Range("B4:B8")? Any help would be appreciated,

Tganks,


E

--
Excelenato

-----------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...fo&userid=3676
View this thread: http://www.excelforum.com/showthread.php?threadid=56788