Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Naming
Can I use a name twice in a workbook, only in different sheets? That is to
say can I have Name "Area1" for "Sheet 1!$A$1:$F$10" and also have Name "Area!" for "Sheet2!$A$1:$F$14" I tried the above but it didn't work. I'm not sure if it can't be done or I did something wrong. Thanks for the help.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Naming
Yes.
When you name the range--either by typing in the namebox (to the left of the formula bar) or by using the Insert|name dialog, make sure you include the name of the sheet. 'Sheet 1'!Area1 (since "Sheet 1" (with the space character) requires the name be in single quotes/apostrophes.) "Bruce A. Julseth" wrote: Can I use a name twice in a workbook, only in different sheets? That is to say can I have Name "Area1" for "Sheet 1!$A$1:$F$10" and also have Name "Area!" for "Sheet2!$A$1:$F$14" I tried the above but it didn't work. I'm not sure if it can't be done or I did something wrong. Thanks for the help.. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Naming
It has been my experience with xl2003 that when you type in the name in
either place, IF you are on the desired sheet, excel will FILL IN the sheet name for you. -- Don Guillett Microsoft MVP Excel SalesAid Software "Dave Peterson" wrote in message ... Yes. When you name the range--either by typing in the namebox (to the left of the formula bar) or by using the Insert|name dialog, make sure you include the name of the sheet. 'Sheet 1'!Area1 (since "Sheet 1" (with the space character) requires the name be in single quotes/apostrophes.) "Bruce A. Julseth" wrote: Can I use a name twice in a workbook, only in different sheets? That is to say can I have Name "Area1" for "Sheet 1!$A$1:$F$10" and also have Name "Area!" for "Sheet2!$A$1:$F$14" I tried the above but it didn't work. I'm not sure if it can't be done or I did something wrong. Thanks for the help.. -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Naming
It only does it in the "Refers to" area, not in the "Names in Workbook"
area. "Dave Peterson" wrote in message ... I've never seen that behavior and I can't get xl2003 to do it now. You aren't writing about the "refers to" area are you? I meant the "Names in workbook" area. Don Guillett wrote: It has been my experience with xl2003 that when you type in the name in either place, IF you are on the desired sheet, excel will FILL IN the sheet name for you. -- Don Guillett Microsoft MVP Excel SalesAid Software "Dave Peterson" wrote in message ... Yes. When you name the range--either by typing in the namebox (to the left of the formula bar) or by using the Insert|name dialog, make sure you include the name of the sheet. 'Sheet 1'!Area1 (since "Sheet 1" (with the space character) requires the name be in single quotes/apostrophes.) "Bruce A. Julseth" wrote: Can I use a name twice in a workbook, only in different sheets? That is to say can I have Name "Area1" for "Sheet 1!$A$1:$F$10" and also have Name "Area!" for "Sheet2!$A$1:$F$14" I tried the above but it didn't work. I'm not sure if it can't be done or I did something wrong. Thanks for the help.. -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Naming
When I select h1 and goto the name box (left of formula box) and put in joe
without sheet name or quotes the defined name.refers to box =Sheet7!$H$1 When I insertnamedefinetype in Bill and enter $h$2 in the refers to box, I get =Sheet7!$H$2 When I do the macro below I get the same result Sub doname() Range("h3").Name = "Sam" End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Dave Peterson" wrote in message ... I've never seen that behavior and I can't get xl2003 to do it now. You aren't writing about the "refers to" area are you? I meant the "Names in workbook" area. Don Guillett wrote: It has been my experience with xl2003 that when you type in the name in either place, IF you are on the desired sheet, excel will FILL IN the sheet name for you. -- Don Guillett Microsoft MVP Excel SalesAid Software "Dave Peterson" wrote in message ... Yes. When you name the range--either by typing in the namebox (to the left of the formula bar) or by using the Insert|name dialog, make sure you include the name of the sheet. 'Sheet 1'!Area1 (since "Sheet 1" (with the space character) requires the name be in single quotes/apostrophes.) "Bruce A. Julseth" wrote: Can I use a name twice in a workbook, only in different sheets? That is to say can I have Name "Area1" for "Sheet 1!$A$1:$F$10" and also have Name "Area!" for "Sheet2!$A$1:$F$14" I tried the above but it didn't work. I'm not sure if it can't be done or I did something wrong. Thanks for the help.. -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Naming
But the name itself does not include the sheet name--it's a global/workbook
level name unless you do the extra typing (of that sheet name) to make it a local/sheet level name. And for the OP, it was important to make the names local/sheet level so that the names could be used on multiple sheets. Don Guillett wrote: When I select h1 and goto the name box (left of formula box) and put in joe without sheet name or quotes the defined name.refers to box =Sheet7!$H$1 When I insertnamedefinetype in Bill and enter $h$2 in the refers to box, I get =Sheet7!$H$2 When I do the macro below I get the same result Sub doname() Range("h3").Name = "Sam" End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Dave Peterson" wrote in message ... I've never seen that behavior and I can't get xl2003 to do it now. You aren't writing about the "refers to" area are you? I meant the "Names in workbook" area. Don Guillett wrote: It has been my experience with xl2003 that when you type in the name in either place, IF you are on the desired sheet, excel will FILL IN the sheet name for you. -- Don Guillett Microsoft MVP Excel SalesAid Software "Dave Peterson" wrote in message ... Yes. When you name the range--either by typing in the namebox (to the left of the formula bar) or by using the Insert|name dialog, make sure you include the name of the sheet. 'Sheet 1'!Area1 (since "Sheet 1" (with the space character) requires the name be in single quotes/apostrophes.) "Bruce A. Julseth" wrote: Can I use a name twice in a workbook, only in different sheets? That is to say can I have Name "Area1" for "Sheet 1!$A$1:$F$10" and also have Name "Area!" for "Sheet2!$A$1:$F$14" I tried the above but it didn't work. I'm not sure if it can't be done or I did something wrong. Thanks for the help.. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Naming
My old brain failed to see that......
-- Don Guillett Microsoft MVP Excel SalesAid Software "Dave Peterson" wrote in message ... But the name itself does not include the sheet name--it's a global/workbook level name unless you do the extra typing (of that sheet name) to make it a local/sheet level name. And for the OP, it was important to make the names local/sheet level so that the names could be used on multiple sheets. Don Guillett wrote: When I select h1 and goto the name box (left of formula box) and put in joe without sheet name or quotes the defined name.refers to box =Sheet7!$H$1 When I insertnamedefinetype in Bill and enter $h$2 in the refers to box, I get =Sheet7!$H$2 When I do the macro below I get the same result Sub doname() Range("h3").Name = "Sam" End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Dave Peterson" wrote in message ... I've never seen that behavior and I can't get xl2003 to do it now. You aren't writing about the "refers to" area are you? I meant the "Names in workbook" area. Don Guillett wrote: It has been my experience with xl2003 that when you type in the name in either place, IF you are on the desired sheet, excel will FILL IN the sheet name for you. -- Don Guillett Microsoft MVP Excel SalesAid Software "Dave Peterson" wrote in message ... Yes. When you name the range--either by typing in the namebox (to the left of the formula bar) or by using the Insert|name dialog, make sure you include the name of the sheet. 'Sheet 1'!Area1 (since "Sheet 1" (with the space character) requires the name be in single quotes/apostrophes.) "Bruce A. Julseth" wrote: Can I use a name twice in a workbook, only in different sheets? That is to say can I have Name "Area1" for "Sheet 1!$A$1:$F$10" and also have Name "Area!" for "Sheet2!$A$1:$F$14" I tried the above but it didn't work. I'm not sure if it can't be done or I did something wrong. Thanks for the help.. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Naming
I understand (too well!).
Don Guillett wrote: My old brain failed to see that...... -- Don Guillett Microsoft MVP Excel SalesAid Software "Dave Peterson" wrote in message ... But the name itself does not include the sheet name--it's a global/workbook level name unless you do the extra typing (of that sheet name) to make it a local/sheet level name. And for the OP, it was important to make the names local/sheet level so that the names could be used on multiple sheets. Don Guillett wrote: When I select h1 and goto the name box (left of formula box) and put in joe without sheet name or quotes the defined name.refers to box =Sheet7!$H$1 When I insertnamedefinetype in Bill and enter $h$2 in the refers to box, I get =Sheet7!$H$2 When I do the macro below I get the same result Sub doname() Range("h3").Name = "Sam" End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Dave Peterson" wrote in message ... I've never seen that behavior and I can't get xl2003 to do it now. You aren't writing about the "refers to" area are you? I meant the "Names in workbook" area. Don Guillett wrote: It has been my experience with xl2003 that when you type in the name in either place, IF you are on the desired sheet, excel will FILL IN the sheet name for you. -- Don Guillett Microsoft MVP Excel SalesAid Software "Dave Peterson" wrote in message ... Yes. When you name the range--either by typing in the namebox (to the left of the formula bar) or by using the Insert|name dialog, make sure you include the name of the sheet. 'Sheet 1'!Area1 (since "Sheet 1" (with the space character) requires the name be in single quotes/apostrophes.) "Bruce A. Julseth" wrote: Can I use a name twice in a workbook, only in different sheets? That is to say can I have Name "Area1" for "Sheet 1!$A$1:$F$10" and also have Name "Area!" for "Sheet2!$A$1:$F$14" I tried the above but it didn't work. I'm not sure if it can't be done or I did something wrong. Thanks for the help.. -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming a cell | Excel Worksheet Functions | |||
Cell and tab naming | Excel Discussion (Misc queries) | |||
How do I control the cell reference when naming a cell in a macro | Excel Programming | |||
Naming a cell | Excel Worksheet Functions | |||
Naming a Cell | Excel Programming |