renaming a Named Range in multiple workbooks

  • Thread starter Thread starter Tagwim
  • Start date Start date
T

Tagwim

Hello all

I want to be able to rename a "Named Range" (Someone spelled it wrong) and
now I have 1600+ workbooks that I need to change. This could be multiple
places in the workbook itself.

I was thinking that I could possibly do it with VB 6 or VB 2008. I was
hoping that someone may have already had this issue and a quick solutions...

If not then it's on to the coding...

Thanks in advance.

Rob
 
Ron,

A question if I may. The named Range that I am looking to rename may also
be used in calculations. Does this also handle this?

Thank you

Rob
 
Hi Tagwim

If you use something like this

With mybook.Names("tax")
.Name = "taxlow"
End With


And you have a formula like this

=A4*tax

It will change to

=A4*taxlow
 
Really? I tried your example and it didn't change the formula for me. I got
a #NAME? error instead.
 
Rob,

Unfortunately renaming a Name via VBA does not change the name in Formulae
and any other place where the name is referenced.

Name Manager (http://www.DecisionModels.com/downloads.htm) will handle the
renaming in formulae and other places for a single workbook, but 1600 one at
a time would be tough.

Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com
 
Hi Charlie

Working OK here in 2007 where I test it but I see that in Excel 2003 it is different
No time to test it now (tomorrow I will if you not have a answer)
 
Ron,

Thank you it did the trick. Excellent information

Thank you again

Rob
 
Hi Ron,

Thanks, I did not know that (although I knew the native 2007 Msoft Name
manager can do it).

Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference named range in closed workbook 23
Macro for all Excel Workbooks to print to PDF 2
renaming named ranges 4
Save As and new workbook new name used in existing code 8
Copy Multiple Areas from One Workbook to Another 4
Merging Multiple Named Ranges 5
Rename all named ranges? 8
Import multiple workbooks to current workbook in specified row number 0

Back
Top