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
"Tagwim" wrote in message
...
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
"Ron de Bruin" wrote:
hi Tagwim
See this page
http://www.rondebruin.nl/copy4.htm
You can change the red code block to do what you want
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Tagwim" wrote in message
...
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