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