VBA to find text and show the number of occurances in msg box

Hi,

With the help of VBA, i am able to find the data in column P. Few of the cell of column P has text "Not found".

I need VBA which just find this text entire column P and tell me the number of occuraces

Msg "4 occuraces of not found record"

Thanks

I get error below error code

Please Login or Register  to view this content.

With the help of your code, made below tweak. It works for me now.

Please Login or Register  to view this content.

Thanks hectop


Regards,

hectop's code works for me.

can you post workbook example that shows the error you are getting

Thanks Andy..

Got it worked around.

care to reveal how you worked around?