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...

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


wrote:

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...

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


wrote:

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...


.