=INDEX(B1:B100,MATCH(MAX(A1:A100),A1:A100,0),1)

where the range you want to search Max is A1:A100 and you want to return the
cell in B1:B100.

Regards,
Peter T

<Anandh R wrote in message ...
I need a macro to find a max value for range of cells and also the value of
the cell adjacent to max cell.
i should input the range while running the macro.

kindly help me in this ...


Submitted via EggHeadCafe - Software Developer Portal of Choice
EggheadCafe Stock Quote WebService
http://www.eggheadcafe.com/tutorials...k-quote-w.aspx