View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Allen Brian Allen is offline
external usenet poster
 
Posts: 3
Default Going to cell with maximum value

I need a function or macro to select cells with the ten highest values
in selected rows over 25 worksheets. I am not looking the maximum of
each sheet. It is possible all ten could be in one sheet. I have a
feeling the code would need to loop through all 2024 numbers, placing
them in an array and sorting from maximum to minimum - grab the ten
with the highest value then activate the cells with the maximums so
that they can all changed to a set value.

Any suggestions