Searching for specific text


  • This is what I have for my code


    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:



    Alastair

    Einstein:
    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!