mcro coding

[flyer]

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

 

[Frank Kabel]

Hi
in a macro to get the row numbers try

dim rng
set rng = activesheet.range("A1:A1000")
with application.worksheetfunction
msgbox .match(.max(rng),rng,0)
end with