I found the following excerpt from an e-letter published in 1999.

************************************************** ******************
Created by Bob Umlas and David Hager
To define a global range name in Excel, go to Insert, Name, Define and,
as an example, in the Names in Workbook box type "cellA1" and in the Refers
To box type this formula: =OFFSET(!$A$1,,,,). Now, type =cellA1 in a cell
on any worksheet in the workbook and it will return the value in A1 for
that worksheet.
************************************************** ******************

Dave P., I didn't search for this. It just stared at me and I couldn't resist.

I am not sure if I *truly* understand the above formula. You know, sometimes things look simple and yet it can turn out to be quite complicated. I wonder if it will cause the same problems that !$A$1 will. If anyone remembers the details of the problems, please share with us.

Can someone convince me why I want to go thru all this instead of just keying in =A1? :)

If I have more than just A1, but a range instead (e.g.A1:A10), how do I adjust the above formula to include :A10? Where do I put the commas? Why do we need them? Less than eight characters?

I hope this is not outdated. If it is, please let me know.

Thanks.

Epinn