Maximum value from multiple worksheets

[Brian Allen]

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.

 

[rmc5446]

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

 

[merlin]

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.

 

[Brian Allen]

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.