Optimizing Excel macro to find/replace with the list of data contained in the macro

Originally Posted by royUK

What is username1 and where is it given a value?

Can you attach a sample workbook?

Username 1 is the persons username. First Last is the persons first and last name.

The code that I posted is straight from the macro. I shortened it by not including all of the usernames and all of the first last names (it's the same snippets of code just changed to look for each of my users. It just seems like there might be a more efficient way to do this.....

Here's a scenario:

Someone from a diff team will send me a sheet and ask me if any of my users are in the sheet
I run the macro
If the sheet had people sorted by their usernames and UserName1 is contained; it will be highlighted in red
If the sheet is sorted by first and last name and First last1 is in the list, the text will be highlighted in green

Simply build an array, either in the actual workbook or elsewhere that has a list of the names to be looked for, and what to replace with, 2 columns column A has the look for, Column B has the replace with.

Use 2 primary variables to reference those to columns and use a for loop to loop through each one until it reaches the end, repeating the primary objective with each loop. If I had time I'd build an example but I'm being run out of here so I don't get OT pay. If your still having trouble, or somone else doesn't jump on it, then I'll work on an example tomorrow on my lunch