How to select range of cells that equal certain value...need help improving code.

I have this code to select range of cells that equal to China in a master sheet. However i know this code can be simplified. Can you guys help me? Basically i want to select a column A cells of a country in a mastersheet. Can't figure out how to improve this.

Please Login or Register  to view this content.

Thank You

Hi,

If you column A don't contains blank cells in between you can use filter technique to select the cells with China in it with the below code.

Please Login or Register  to view this content.

Awsesome thank you!!

Thats because in cell A5 & A6 you have extra trailing space what you see as "BS" is actually "BS ". SO deleting those extra spaces will give you the result.

See the file.