Replacing Texts in a Table Column using VBA

[bambino86]

Hi,

I have a table with a list of names that I need to replace. There are corresponding replacements for some of the names. The names that do not have replacement names should be retain it's original names. How do I automate this using VBA? The code should stop only until the last non-blank cell.

thanks

[jindon]

Please Login or Register  to view this content.

[Logit]

.

Please Login or Register  to view this content.

Paste into a routine module.

[bambino86]

Thanks for the code. However, my range is dynamic and I will be updating the column from time to time. Can the code not be limited to specific range only?

[Logit]

What range in Col A will you be using ?

[Logit]

.
If your used range in col A will be ever changing, you can utilize this macro instead:

Please Login or Register  to view this content.