View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Max value in same cell across ALL worksheets

"Corey" wrote in message
...
When i place that in the formula box and hit enter, it opens up a file
dialog box?

Is that right ?


No!

I don't think I can explain it any better than I already have.

What is the name of the very first tab in your file?
What is the name of the very last tab in your file?

The formula is:

=MAX(name of the very first tab in your file:name of the very last tab in
your file!I12)

Biff