add names
I have to define a few dozens of names in an Excel files. I put all the names
in Range ("A1:A35") and their respective addresses in Range ("B1:B35"), such
as "sheet1!$a$1:$c$20". What is the macro to run this job?
Also, want to know what are the codes to delete all these names later on if
necessary.
Thanks.
|