Using Cell Find in VBA highlight multiple Row

**evosurf** · 01-19-2013, 08:43 PM

Hi I am new to VBA and I need help.

I want to find a text in a worksheet which repeats itself multiple time. Then i want to select the entire row which contain that text and add a style "Good"

The code below only only adds style to the first row and not the rest.

Please Login or Register  to view this content.

**smuzoen** · 01-19-2013, 09:44 PM

You could use something like the following which will find a range containing the values you are searching for (in this case "Run")

Please Login or Register  to view this content.

**evosurf** · 01-19-2013, 10:11 PM

Thanks you for the quick response.

The code works. I ran it with open workbook. I really appreciate you assistance.

I notice that when running the code it took alot of processing power and time for it to complete over 60000 rows of records.

I will use the above code for now unless someone knows a faster way of doing this.

I was thinking about what if i create a key where the content is only column A rather then searching the entire workbook.

**smuzoen** · 01-20-2013, 12:12 AM

If the content is only in column A then the code should be amended to

Please Login or Register  to view this content.

The way you worded your question was that the word "Run" could be anywhere - as such I made the search range the entire sheet - condensing it to column A would be faster. If you only wanted to colour the cell with the word then I would use conditional formatting rather than using VBA