How to find a max value from a list?

[Ken Wright]

One way

m = Application.WorksheetFunction.Max(Range("A1:A30"))

 

[Norman Harker]

Hi Stefan!

You could put =MAX(YourRange) in a cell and that becomes your
variable. You could also name that cell by selecting it and typing a
name in the name box to the left of the formula bar (then press
enter). That then becomes the name of the variable.

Or you could used a defined formula.

Insert Name Define
Type a name such as MyMax
In refers to type (eg) =MAX(J1:J50)
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Stefan Jansson]

How do I find the max value from a list of numeric values and store that
value in a variable?

Regards
Stefan

 

[Stefan Jansson]

Thanks a lot! It works fine. (Both do)

Stefan

One way

m = Application.WorksheetFunction.Max(Range("A1:A30"))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission
-------------------------------------------------------------------------- --