I would like to write a code that calculates the min and max in a range of
cells and compares them in order to find the cell that contain both values.
this has to be done in several rows.

For example:
The data are from cells(4,7) to Cells(4,11)
What should I write to get the min and assign it to a variable name ?
I wrote : Mmo = MIN(cells(4,7):Cells(4,11)) , but it is not correct
--
Thanks , Moises

Mmo = Application.WorksheetFunction.Min(Range("G4:K4"))

--
Dan

On Jan 11, 2:17*pm, Moises wrote:
I would *like to write a code that calculates the min and max in a range of
cells and compares them in order to find the cell that contain both values..
this has to be done *in several rows.

For example:
The data are from cells(4,7) to Cells(4,11)
What should I write to get the min and assign it to a variable name ?
I wrote * : *Mmo = MIN(cells(4,7):Cells(4,11)) * , but it is not correct *
--
Thanks , Moises

Many thanks!
--
Moises


"Moises" wrote:

I would like to write a code that calculates the min and max in a range of
cells and compares them in order to find the cell that contain both values.
this has to be done in several rows.

For example:
The data are from cells(4,7) to Cells(4,11)
What should I write to get the min and assign it to a variable name ?
I wrote : Mmo = MIN(cells(4,7):Cells(4,11)) , but it is not correct
--
Thanks , Moises