l=Application.min(Range("D4:D7")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ed" wrote in message
...
I have trouble assigning the min value of a rangein a macro to a
variable say "m".

I tried:

l=min(Range("D4:D7")

and get the message:

" Compile error
Sub or function not defined"

How can I correct the error?


Thanks,


Ed