Sub mincells()
MsgBox Application.Min(Range("g1,g3,g5,g9"))
End Sub

--
Don Guillett
SalesAid Software

"Ed" wrote in message
...
How do I code a " Range" of cells that are not in order?

I tried to get a min in a group of 4 scattered cells with numerical
values using:

Application.Min(Range("C4","C7","C11","C14"))

with no success.

What code would I use get the min of those 4 cells?

Thanks,


Ed English