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

--
rbmc
-----------------------------------------------------------------------
rbmcc's Profile: http://www.excelforum.com/member.php...fo&userid=3060
View this thread: http://www.excelforum.com/showthread.php?threadid=53384