Faster way to find and replace multiple values with corresponding values

I currently have a macro, which I recorded, that finds a value and replaces it with another. There are about 20 things that I want to find and replace, which takes a while because it does each one after the other. Is there a way to put them in an array and loop through to make the process run faster? A bit of the code is below.

Please Login or Register  to view this content.

hi babbeleme1, example:

Please Login or Register  to view this content.

It works perfectly. Still a bit slow for my liking, but at least faster than mine. Thank you so much watersev!

to make it faster:
1. Do not use Cells...., define exact range
2. Add before For .. next

Please Login or Register  to view this content.

Oh okay! Turning screenupdating off will just make it all come up at once, right?
What do you mean by "Do not use Cells....define exact range" ?

I doubt you use around 1000000 rows by around 32000 columns data block. Using

Please Login or Register  to view this content.

would instruct Excel to check all those millions which I'm sure ar not used even halfly

Great! Made both changes and it's significantly faster. Thank you so much watersev!