macro to automatically select certain cells.

[topi1]

I have a worksheet called "Home". Some of the cells from A1 to Z50 can be populated with the word "Yes". Is there a macro which when activated will only select (click) cells in the range which contain the word "Yes".

Thanks I advance for all your help.

 

[topi1]

That did the job. I have no VBA knowledge but because of help from people like you, I have been able to create a file which will be very helpful to us at work. Thank you much. Keep up the good work.

 

[Christea685]

That did the job. I have no VBA knowledge but because of help from people like you, I have been able to create a file which will be very helpful to us at work. Thank you much. Keep up the good work.

Topi1 - I am completely self taught. 9 months ago I started dabbling in code out of pure necessity. I used this, google, VBA for Dummies and A LOT of long nights and I'm now not only writing complex codes, I'm teaching Macro Classes to my company. Stick with it!!!! Whenever I find cool code, or learn something new I just dump it into a module in my personal workbook to refer to later.

 

[topi1]

You should be proud.