Code to replace names in cells

  • Hi All,

    I have a rather large database, filled with certain color names in certain columns.
    I am looking for a code to loop through the range where the colors names are, and replace certain color names with a different name.
    Some cells have other data (can be anything) - and those cells should be left intact.
    Some cells are empty and should be left empty.
    Some of the colors names might have some symbols in them ("." or "/" or "&", etc.).
    There are about 80 color names in my real-life database and all need to be changed/replaced with a different name.

    I assumed the best way to do it is to use a "for each" loop & "select case" and I struggled with it quite a bit, without success.
    I am attaching a sample data base, showing what I need.
    Any help/pointers will be greatly appreciated.


  • Re: Code to replace names in cells

    Maybe something like this:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!