Thread: Range Names
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim May Jim May is offline
external usenet poster
 
Posts: 477
Default 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..