Range

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

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
 
Sub mincells()
MsgBox Application.Min(Range("g1,g3,g5,g9"))
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Junp start my Select Case Macro 12
VBA set thick borders around non empty cells in range 0
Shifting rows down in a table 2
Un Protect in Excel 2000 1
Arrays and scattered cell values or another way? 16
Orderly Validation Against Separate Ranges 8
Get max & min dates from column 4
A simple if <> nn then Msgbox "No Match" 5

Back
Top