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.
|