To select rows based on certain Criteria

Hello All,

I am new to Excel Programming. Here is my Question.

I want to select rows based on certain cell value. Suppose if I have a coloumn "Company Name" . If any cell in that coloumn has company name Accenture it has to be selected. In this way I have some 532 company names. I have written a piece of code to select for one company and it worked.
I am not sure how to write code for 532 companies.

Here is my code:

Sub Select_Cell()

ActiveSheet.Range("F1:F16676").Select

Range("F1:F16676") = "ACCENTURE"

ActiveCell.Select

End Sub

Please help me.

Regards,
Myth