Maximum value from multiple worksheets
 

I wish to use a macro or function to activate the cell with the
maximum value. As many as 25 worksheets are involved. Each worksheet
will have a row selected. Any suggestions.

Maximum value from multiple worksheets
 

this may seem too obvious but why not create a summary page that has al
the rows from your 25 worksheets and us the max function

--
rmc544
-----------------------------------------------------------------------
rmc5446's Profile: http://www.excelforum.com/member.php...fo&userid=1600
View this thread: http://www.excelforum.com/showthread.php?threadid=27475

Maximum value from multiple worksheets
 

"Brian Allen" schreef in bericht
om...
I wish to use a macro or function to activate the cell with the
maximum value. As many as 25 worksheets are involved. Each worksheet
will have a row selected. Any suggestions.

Use a macro to grab all maximums from all sheets to collect them in an
array, or even in a 'dummy sheet' if that's easier.
After that, get the maximum from your new collection.

Maximum value from multiple worksheets
 

rmc5446 wrote in message ...
this may seem too obvious but why not create a summary page that has all
the rows from your 25 worksheets and us the max function?


I have to activate the cells with the ten highest values and alter
them. It is possible that the ten highest values out of 2024 may all
be on the one worksheet. So I need a method to store all the values
(2024)and then activate the ten cells that contain the highest values.