Just an alternative:

Insert/Name/Define:
Name in workbook customcell1
Refers to: =!$A$1

Advantage: you can use customcell1 in every sheet in the workbook, and
it will refer to cell A1 on that sheet. No need to enter multiple
sheet-level names.

Disadvantage: you can't refer to the named range on another sheet -
e.g., =Sheet1!customcell1 will return #REF!.



In article ,
"Bob Phillips" wrote:

When you create the name, precede it with the sheet name (001!$A$1), and it
will be local to that sheet. Then on sheet2, use 002!$A$1, etc.