Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to reconcile multiple names for same customer | Excel Discussion (Misc queries) | |||
How do I sort multiple names within one cell? | Excel Worksheet Functions | |||
Changing Multiple Defined Names At Once? | Excel Discussion (Misc queries) | |||
Can I change the names of multiple cells at once? | Excel Discussion (Misc queries) | |||
How do i Print Multiple Names on the same Timesheet? | Excel Worksheet Functions |