| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning a min to a variable
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assigning a min to a variable
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assigning a min to a variable
That did it. Thank you.
ed English On Thu, 3 Aug 2006 16:54:08 +0100, "Bob Phillips" wrote: l=Application.min(Range("D4:D7") |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assigning a min to a variable
VBA doesn't have a min function, so use the worksheet equivalent
l=WorksheetFunction.min(Range("D4:D7") -- Regards, Tom Ogilvy "Ed" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning values to a variable set | Excel Discussion (Misc queries) | |||
| Assigning a variable | Excel Worksheet Functions | |||
| Assigning a variable a value from a Cell in VBA | Excel Programming | |||
| Assigning a row to a variable | Excel Programming | |||
| Re-assigning the value of a variable for a for loop from | Excel Programming | |||
Hybrid Mode
