Range
 

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

Range
 

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

Range
 

Thanks


On Fri, 4 Aug 2006 06:59:31 -0500, "Don Guillett"
wrote:

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

Range
 

glad to help

--
Don Guillett
SalesAid Software

"Ed" wrote in message
...
Thanks


On Fri, 4 Aug 2006 06:59:31 -0500, "Don Guillett"
wrote:

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