Obtaining min and max

[Ed]

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

[Excelenator]

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

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

[moon]

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


"Ed" <[email protected]> schreef in bericht
news:[email protected]...
> 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

[Ed]

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" <[email protected]>
wrote:

>=min(B4:B8)
>=max(B4:B8)
>
>
>"Ed" <[email protected]> schreef in bericht
>news:[email protected]...
>> 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
>

[Ed]

Thanks to all. Still having difficulty. Posting new message



On Thu, 03 Aug 2006 08:43:10 -0500, Ed <[email protected]> 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