Hi Chris,

Instead of just being
able to alter the name, it seems I have to:

• add a new name
• go through the workbook and do a find/replace (checking each one to
make sure its the correct name to change - eg. the name input_location
vs. a title "Location")
• delete the old name
• go through the VBA and do a find/replace (once again checking each
occurrence)

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