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

Tganks,


Ed

=min(B4:B8)
=max(B4:B8)


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

Tganks,


Ed

=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

When I tried to assign the min of a range in a macro to the variable l
using:

l = Min("D4:D7")

I get the message:

Compile error
Sub or function not defined


How can I get it to work?

Thanks

Ed



I used the code l = Min("D4:D7") in a macro to assign the min of a
range




On Thu, 3 Aug 2006 15:51:12 +0200, "moon"
wrote:

=min(B4:B8)
=max(B4:B8)


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

Tganks,


Ed

Thanks to all. Still having difficulty. Posting new message



On Thu, 03 Aug 2006 08:43:10 -0500, 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,


Ed