Click on B12; hold CTRL, click on B40 then on B65; type mydata in Name box
and pres ENTER
Use =MAX(mydata) or LARGE(mydata,1) ---- you can also use LARGE(mydata,2)
for next largest

Multiple sheets: MAX(MAX(Sheet1!A1:A10), MAX(Sheet2!B2:B20)
Or expand on the name method
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"telewats" wrote in
message ...

This is good to know. Thanks for the info.

What if I want to use cells that aren't in conjunction with one
another, ie. B12 & B40 & B65? Or if I want to pull data from multiple
spreadsheets?


--
telewats
------------------------------------------------------------------------
telewats's Profile:
http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=499387