Tanks for the update.

Your spreadsheet works great...I played around with it and I discovered the reason why it did/does not work in my spreadsheet.

If the contents of cell "d" is just one word it will replace cat with dog and red with blue, etc. Here is what is happening...in my cell "d" I have a sentence "The man walked the dog." I thought just the word "dog" would be replaced with "cat"...instead it did nothing at all...I tested this by taking out the sentence and just putting in the word "dog", and it worked just the way it was supposed to...Funny, I would think that when I ran it the first time it would have replaced the whole sentance (contents of the cell d sheet 2) with the one word replacement from column b sheet 1.

Your additional comments are great and I understand what is going on...well maybe not completely...so why would not the entire contents of each cell in d be replace with the corresponding word from sheet 1 column d? and why does it not work when the word is embedded in a sentence?

I like the loop, simple and elegant...it sure beats having to do a counter for each cell, like I originally was doing.

This is great!..you have me thinking and I'm learning...any additional help with the above questions is greatly appreciated.

Thanks...EXLNeophyte