mcro coding

F

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
 
F

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
 
Top