Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Names
If when I go into the Insert, Name Define Dialog box
and see Certain range names with 2 columns of data; that is, Col 1 the Name - Col 2 the Sheet Name... What do I have? I didn't intend on having any Range Names Specific to a sheet but I guess that is what I have. Are there any Disadvantages to doing this? Also in some of my SIngle-Col Range Names in the RefersTo box I see the formula ='Cost Analysis'!$A$11 (say) This of course is because I have spaces in the sheet name. For some of those that have the SHeet Specific (2 Col) In the Refers to box I see =PayShedule!$G$12. I tried changing one to ='PaySchedule'!$G$12 and it wouldn't accept it - it reverted back to =PayShedule!$G$12 after pressing the enter key. Any comments that would educate me a bit more in this area would be appreciated.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Names
"Jim May" wrote in message ... If when I go into the Insert, Name Define Dialog box and see Certain range names with 2 columns of data; that is, Col 1 the Name - Col 2 the Sheet Name... What do I have? I didn't intend on having any Range Names Specific to a sheet but I guess that is what I have. Are there any Disadvantages to doing this? That is exactly what you have. Unless you specifically want sheet specific names, I would remove them and set them up as global names as local names can get very confusing. Also in some of my SIngle-Col Range Names in the RefersTo box I see the formula ='Cost Analysis'!$A$11 (say) This of course is because I have spaces in the sheet name. For some of those that have the SHeet Specific (2 Col) In the Refers to box I see =PayShedule!$G$12. I tried changing one to ='PaySchedule'!$G$12 and it wouldn't accept it - it reverted back to =PayShedule!$G$12 after pressing the enter key. What exactly is the question here? If a sheet has no spaces, it doesn't need the quotes. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Names
In , Bob Phillips
spake thusly: "Jim May" wrote in message ... If when I go into the Insert, Name Define Dialog box and see Certain range names with 2 columns of data; that is, Col 1 the Name - Col 2 the Sheet Name... What do I have? I didn't intend on having any Range Names Specific to a sheet but I guess that is what I have. Are there any Disadvantages to doing this? That is exactly what you have. Unless you specifically want sheet specific names, I would remove them and set them up as global names as local names can get very confusing. How does one do this? I'm confused, because I did set up some global names, but when I save name Excel 2002 inserts the sheet name. I don't see how to leave it off. Or is that something else from what the discussion has been about? Dallman Ross |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Names
Bob Thanks, I guess I'm saying that I DID NOT intentionally make these
several Range Names Specific or Local -- How can this occur (RN getting set up locally)? Is there a Formal way (Rule specific) for setting up Global Names? If so, what are the rules? Dallman seems to also be having some problems;;,, hummmm Apprecaite your help, Jim "Bob Phillips" wrote: "Jim May" wrote in message ... If when I go into the Insert, Name Define Dialog box and see Certain range names with 2 columns of data; that is, Col 1 the Name - Col 2 the Sheet Name... What do I have? I didn't intend on having any Range Names Specific to a sheet but I guess that is what I have. Are there any Disadvantages to doing this? That is exactly what you have. Unless you specifically want sheet specific names, I would remove them and set them up as global names as local names can get very confusing. Also in some of my SIngle-Col Range Names in the RefersTo box I see the formula ='Cost Analysis'!$A$11 (say) This of course is because I have spaces in the sheet name. For some of those that have the SHeet Specific (2 Col) In the Refers to box I see =PayShedule!$G$12. I tried changing one to ='PaySchedule'!$G$12 and it wouldn't accept it - it reverted back to =PayShedule!$G$12 after pressing the enter key. What exactly is the question here? If a sheet has no spaces, it doesn't need the quotes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference to range names | Excel Discussion (Misc queries) | |||
not delete worksheets from names in a range | Excel Discussion (Misc queries) | |||
Range Names | Excel Worksheet Functions | |||
Excel Range Names | Excel Discussion (Misc queries) | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions |