LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How to load multiple names ?

Excel 2003 question.
Hello,
I have a file with about 200 names. I pasted the list of these names
(Insert/Name/Paste...) in a tab. In the first column, there are the names and
in the second one, the corresponding ranges.
As I have to change many ranges, I manually changed them in the pasted list.
Now I would like to reload all the names in once but I do not know if it is
possible and how to do it. It is really too long to change all name ranges
one by one with the Insert/Name/Define.
If not possible, is a macro able to perform it ?
Thank for your help.
 
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
how to reconcile multiple names for same customer charlenegrelli Excel Discussion (Misc queries) 1 July 4th 07 01:04 AM
How do I sort multiple names within one cell? Deborah P. in Charlotte Excel Worksheet Functions 2 October 10th 06 06:34 PM
Changing Multiple Defined Names At Once? Wuddus Excel Discussion (Misc queries) 3 September 26th 06 12:57 AM
Can I change the names of multiple cells at once? shadestreet Excel Discussion (Misc queries) 8 May 31st 06 12:55 AM
How do i Print Multiple Names on the same Timesheet? FountainSpark Excel Worksheet Functions 0 February 10th 06 10:49 AM


All times are GMT +1. The time now is 07:23 PM.

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

About Us

"It's about Microsoft Excel"