Replace Multiple Text in Column from a List

Confused
Where is Sheet2 ?

Sorry my bad should be there now
Regards
Graham

Try this.
Macro/VBA on the two buttons.
Obviously one button is redundant (only there to reset).
Simple loops, no formula on sheet, should accommodate expanding lists.
torachan.

@Graham.
I omitted to say, I removed table from sheet 2 and just used the data.
With the table occupying the entire column it causes a count overflow.
torachan.

According to the initial attachment :

PHP Code: 

Sub Demo()
             Dim Rg As Range
             Application.ScreenUpdating = False
    With Sheet1.UsedRange.Columns(4)
        For Each Rg In Range(Sheet2.[A2], Sheet2.Cells(Rows.Count, 1).End(xlUp))
            .Replace Rg.Value2, Rg(1, 2).Value2, xlWhole
        Next
    End With
             Application.ScreenUpdating = True
End Sub 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

@Graham
Your original code actually works when sheet 2 is present.
See the attached the only amendment I have made is to cover the full range sheet 2, rows 2 to 25.
torachan.

As a self confessed "speed-freak" I always like to add to my limited knowledge.
This simple exercise with its various solutions proved very informative.
To illustrate I put all the solutions together so that they tested the same various ranges.
Using the OP original list as a 'seed' then created various quantity of row (numbers-->)10,000 to 100,000.
I declare 'jolivanes' the winner, in second place 'graham', myself a dismal third, with 'Marc' a faller at the first fence.
torachan.

For "speed-freak" torachan.
Another one to try on 300,000+ rows.

Please Login or Register  to view this content.

@ jolivanes,
Unbelievable,
Your old version 300,000 rows(22.59 secs), 500,000 rows(37.59 secs)
New version 300,000 rows(1.59 secs), 500,000 rows(2.57 secs)
Even on my old 'steam driven computer' running Excel 2010.
Last time I saw performances like that was when I change running my 'dragster' on injection/methanol to supercharger/nitro back in the 70's.
torachan.

First of all I want to thank you all in this veru enjoyable debate on this code.
You have helped me a lot and I now consider this query closed as it has been very successful indeed
You guys are awesome in your help for others, and i was thinking that this is the only user group that is moving forward.
Thanks a lot to all of you
Regards
Graham

@torachan.
Nice to hear you like it Don (Garlits)

@Graham
Never too old to learn from some old "geezers".
Good Luck