changing 'names'

G

Guest

Hi,

I use a set of string variables (ussually ppls names) in
defining names, worksheet names, formula, base data, VB
macro's etc. These string variables I am quite sure are
unique. ie won't appear as a part of another word.

I now want to make the whole spread sheet generic. Is
there a way of doing a search and replace on the whole
spreadsheet based on a search for the string that I want
to replace?

eg i may have the name jon in : worksheet name -> jon
worksheet
and
i may have the name jon in name : jon_list -> refer to
list a1 to n240
i may have the name jon in cell : a56 = "jon"

and I want to change all the 'jon' strings
into 'person_one'


Thanks in advance...
 
K

keepITcool

For all name management use this superb addin:
Name Manager from jan karel pieterse
available from http://bmsltd.ie/MVP/Default.htm

I've dabbled with a Name Editor of my own to allow changing names WITH
automatic update of all formulas and names pointing to the name to be
changed.

It's not fool/bug proof but you may give it a go:
available from http://members.chello.nl/keepitcool/download.html


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
G

Guest

Thats perfect... thanks.

-----Original Message-----

For all name management use this superb addin:
Name Manager from jan karel pieterse
available from http://bmsltd.ie/MVP/Default.htm

I've dabbled with a Name Editor of my own to allow changing names WITH
automatic update of all formulas and names pointing to the name to be
changed.

It's not fool/bug proof but you may give it a go:
available from http://members.chello.nl/keepitcool/download.html


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >




.
Click to expand...
 
Top