Hello,

I am kinda new to VBA and I am trying to count how many times a keyword (ECAP (10%---20%) ) repeated in column "A" in a sheet.

I tried but results are not right, if someone can give me a helping hand, that would be great.

 j = ActiveSheet.Range("A2:A2000").Find("ECAP (10%---20%) ").Count
Thanks in advance, Anil