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