macro

H

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
 
D

Don Guillett

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