Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
named ranges
I got a sample excel worksheet from KYd
http://www.exceluser.com/dash/gauges_no.htm and in one workbook, they use the same range name on multiple tabs, and when I go to tab 1 hit F5 select range name "alpha" i am taken to a location on tab 1 then I goto tab 2 hit F5 select range name "alpha" i am taken to a location on tab 2 I try to duplicate thsi and can't? Any ideas |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
named ranges
UsGrant_75
You can have the same name on muliple sheets if you create the name to include the sheet name. For example if your first sheet is named "worksheet1" and your second sheet is called "worksheet2" in the define names dialog you can create myrange on both by including the sheet name with your selection ie worksheet2!myrange. Dave "UsGrant_75" wrote in message ... I got a sample excel worksheet from KYd http://www.exceluser.com/dash/gauges_no.htm and in one workbook, they use the same range name on multiple tabs, and when I go to tab 1 hit F5 select range name "alpha" i am taken to a location on tab 1 then I goto tab 2 hit F5 select range name "alpha" i am taken to a location on tab 2 I try to duplicate thsi and can't? Any ideas |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
named ranges
Nel post
*UsGrant_75* ha scritto: I got a sample excel worksheet from KYd http://www.exceluser.com/dash/gauges_no.htm and in one workbook, they use the same range name on multiple tabs, and when I go to tab 1 hit F5 select range name "alpha" i am taken to a location on tab 1 then I goto tab 2 hit F5 select range name "alpha" i am taken to a location on tab 2 I try to duplicate thsi and can't? Any ideas To define names on Sheet bases, you have to write also the name of the sheet, so if you want a name Mouse on Sheet1, go to menu Insert, Name, Define and in "Names in workbook" type Sheet1!Mouse, then point to Refers to and choose the range on Sheet1, then click Add, in "Names in workbook" type Sheet2!Mouse, then point to Refers to and choose the range on Sheet2, then clic OK. In this way every time you are in Sheet1 and select the name Mouse will be selected the range on Sheet1, the same on Sheet2. -- (I'm not sure of names of menues, option and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing Named Ranges | Excel Worksheet Functions | |||
Named Ranges | Excel Worksheet Functions | |||
dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |