Count the number of occurrences of a substring in Column A entries using VBA
Posted on 2014-07-28
I got thousands of entries in Column A. Part of the string in these entries can be 99-999-99-99 such as ...
I would like a macro ...
... to count the number of entries in Column A in the current worksheet where the sub-string 99-999-99-99 occurs.
The result is to be displayed in D5 of the current worksheet.
Help is much appreciated. Thank you very much in advance.