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