Maximum value in a range

[fahimip]

Morning All,

I need to write some VB code to copy the cell of maximum value from a range of only 2 cells.

Any ideas

 

[stuartford]

if your range of two cells were a1 and a2 then

If Cells(1, 1) > Cells(1, 2) Then
Cells(1, 1).Copy

Else
Cells(1, 2).Copy
End If


just change the cells( , ) referance number for the exact range you need

hope this help

stu

 

[Krishnakumar]

Range("C1") = Application.WorksheetFunction.Max(Range("A1:A2"))

 

[jindon]

Hi
where to?

Sub test()
Range("a1").Value = worksheetFunction.Max(Range("b1:b2"))
End Sub