View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steph
 
Posts: n/a
Default Max Value in a set of data

I am writing a macro to find the max value in a spreadsheet and move that
value along with the value that is next to it and store it in a new cells.
For instance if row 3 contains the max value I want to move A3 and D3 to F2
and G2.