View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
merlin merlin is offline
external usenet poster
 
Posts: 11
Default 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.