Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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..

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
reference to range names duane Excel Discussion (Misc queries) 3 August 2nd 06 10:15 PM
not delete worksheets from names in a range DARREN FONG Excel Discussion (Misc queries) 3 November 11th 05 05:31 PM
Range Names Wes Excel Worksheet Functions 2 June 27th 05 11:36 PM
Excel Range Names trainer2000 Excel Discussion (Misc queries) 1 May 20th 05 08:42 PM
How do I use Range Names listed in a VLookup table in a formula? Essbasedvlpr32 Excel Worksheet Functions 3 December 15th 04 10:11 PM


All times are GMT +1. The time now is 04:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"