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.. |
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 |