"=Sheet1!Max(d5:d12)" for example
=max(Sheet1!d5:d12)
--
Don Guillett
SalesAid Software

"Michael" wrote in message
om...
Hi everyone,

Say you have 2 worksheet in a workbook: Sheet1, Sheet2

In Sheet2, you can read d12 value from Sheet1 using "=Sheet1!d12"

Now, say I have a range in Sheet1, how can I do thing such as (from
Sheet2):

"=Sheet1!Max(d5:d12)" for example?

Reagrds,
Mike