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