Programming Min and Max

[Moises]

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

 

[Dan R.]

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

 

[Moises]

Many thanks!