Assigning a min to a variable

E

Ed

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dim problems 7
Complie error 2
Assigning a Variable to an Expression that Includes a Variable andVBA Property 3
macro to calculate or make/update formula 1
Assign variable value across files 1
Programming Min and Max 2
Some trouble assigning a string to a variable 22
Assigning cell value to range variable 2

Top