macro

[helo]

how do i select through using macros the highest ranging
numbers with 2 specific numbers?
Example
$400 $600 how do i get the macro to select the
$700 $800 highest number in each row? (Row= --> )
$500 $200

 

[Don Guillett]

try
Sub maxinrow()
For Each c In Selection
MsgBox Application.Max(c.EntireRow)
Next
End Sub