Defining a custom-named Range across several worksheets
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.
|