Find/replace

R

rbmcc

I want to replace all instances of a set of values (A1-A81) with th
values and formating in the corrisponding cells in column B (B1-B81).
I need a macro that will search all cells (except for columns A and B
and replace as discribed above.

i.e. if cell A1=Tom and B1= *_Poe,_Tom_*
Any instance of Tom will be changed to *_Poe,_Tom_*

So on and so forth.

If possibly storing the search/replace parameters on a different shee
would be easier, that is an option for me as well.

This is in Excel 2000.

If this isn't possible, how could I write a macro that finds a value
changes that value, then applies formatting? (so that I can manuall
enter all 81 values to accomplish the same thing).

Thanks,
Rus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top