Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Defining a custom-named Range across several worksheets
Hello,
I seem to have a problem: I want to name a range across worksheets. eg. In several worksheets in a workbook I want the cell A1 to be named customcell1. However when I go to the naming feature (Insert Name Define) it always overwrites the previous version... I mean: when I open the window from worksheet '001' I get for range customcell1 ='001'!$A$1. Then when I go to worksheet 002 and open the window I get for the range customcell 1 ='001'!$A$1. If I change it to ='002'!$A$1, then it changes the value of the range in the 001 worksheet too, while I'm certain you can have ranges with the same name on different worksheets. In the Insert Name Define window the name than appears as customcell1 '001', however I can't do it myself it appears... Any help/hints would be appreciated, Best regards, Sven |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Defining a custom-named Range across several worksheets
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. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sven Herremans" wrote in message ... Hello, I seem to have a problem: I want to name a range across worksheets. eg. In several worksheets in a workbook I want the cell A1 to be named customcell1. However when I go to the naming feature (Insert Name Define) it always overwrites the previous version... I mean: when I open the window from worksheet '001' I get for range customcell1 ='001'!$A$1. Then when I go to worksheet 002 and open the window I get for the range customcell 1 ='001'!$A$1. If I change it to ='002'!$A$1, then it changes the value of the range in the 001 worksheet too, while I'm certain you can have ranges with the same name on different worksheets. In the Insert Name Define window the name than appears as customcell1 '001', however I can't do it myself it appears... Any help/hints would be appreciated, Best regards, Sven |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Defining a custom-named Range across several worksheets
Thank you a lot
"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. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sven Herremans" wrote in message ... Hello, I seem to have a problem: I want to name a range across worksheets. eg. In several worksheets in a workbook I want the cell A1 to be named customcell1. However when I go to the naming feature (Insert Name Define) it always overwrites the previous version... I mean: when I open the window from worksheet '001' I get for range customcell1 ='001'!$A$1. Then when I go to worksheet 002 and open the window I get for the range customcell 1 ='001'!$A$1. If I change it to ='002'!$A$1, then it changes the value of the range in the 001 worksheet too, while I'm certain you can have ranges with the same name on different worksheets. In the Insert Name Define window the name than appears as customcell1 '001', however I can't do it myself it appears... Any help/hints would be appreciated, Best regards, Sven |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining Named Range for Lastrow in a specific column | Excel Discussion (Misc queries) | |||
Named-range source-data for pie charts on copied worksheets | Charts and Charting in Excel | |||
Conditional Formatting - 2 Worksheets one Named Range | Excel Worksheet Functions | |||
same named range on multiple worksheets? | Excel Discussion (Misc queries) | |||
Defining maximum value from a named range for charting purposes | Charts and Charting in Excel |