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:

Please Login or Register  to view this content.

Please help me.

Regards,
Myth

Try using the AutoFilter feature. Do a web search for something like Excel AutoFilter tutorial and you will find several useful guides. This could be recorded as a macro if needed.