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