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.
Thanks in advance, Anil![]()
j = ActiveSheet.Range("A2:A2000").Find("ECAP (10%---20%) ").Count
Bookmarks