Searching for specific text

  • This is what I have for my code

    If Cells(row, 3).Value = "=search(""private"",descript)" = 1 Then Rows(row).Interior.ColorIndex = xlNone

    Looking at this part specifically. What I want the code to do is look in column 3 of the worksheet for every instance of word "private" and when it finds it, I want it to shade that whole row clear.

    Any ideas? Thanks a lot for the help.

  • Re: Searching for specific text

    How about this:


    Things should be made as simple as possible, but not any simpler

    Be sure to check out TemplateZone for all your Microsoft Office Needs.
    Get OfficeReady Professional 3.0 here!

Participate now!

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