View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kallysta Kallysta is offline
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.