Jan,

Many thanks for the reply. Yes, I can believe the complexity of
Charles' task :).

I have just tried Flexfind - a powerful little utility. Really useful
indeed, and complements the Name Manager exceptionally well. I'm
following your advice below and its working quite well considering the
task.

Many thanks again for your advice and especially the utilities - very
much appreciated.

Kind regards,
Chris Adams



Jan Karel Pieterse wrote in message ...

I'm afraid that is the only way right now. Charles Williams has been
working on a renaming routine for our Name Manager, but as you can
imagine this is rather complex material, especially when doing it in
slow business hours <g.

I would use the Name Manager in combination with my Flexfind to get this
job done.

You may find the "List" and Pick up" feature of the NM very useful to
quickly create the new names:

1. Click the list button
2. Close the name manager and go to the new list
3. Edit each name's name to create a new name with the same RefersTo
string (better yet, first copy the entire table downwards and edit the
copied rows so you have overview of the old and new situation)
4. Start Name Manager and hit the Pick-up button and follow instructions
to add the new names.

Now you have the names named as you need them and have to start finding
and replacing them. I'd create a two-column table first, listing old and
new names next to each other to keep track.
Then I'd use Flexfind to do the S&R, because it enables:

1. S&R in all (well, as far as I know) objects
2. Single entry confirmation within each formula.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com