<div>
Dear both, <br />
<br />
both codes / formulas work just fine. I suggest splitting the points 350:150<br />
<br />
Thank you very much for your great and swift support. I really appreciate it. Regards, Andreas
</div>


Dear both,

both codes / formulas work just fine. I suggest splitting the points 350:150

Thank you very much for your great and swift support. I really appreciate it. Regards, Andreas

<div>
<div class="content wysiwyg-content">
Dear Experts: <br />
<br />
I got thousands of entries in Column A. Part of the string in these entries can be 99-999-99-99 such as ...<br />
<br />
P:\\Graphics\\MyFolder\\99<wbr />\\99-999-9<wbr />9-99.tif<br />
<br />
I would like a macro ...<br />
... to count the number of entries in Column A in the current worksheet where the sub-string 99-999-99-99 occurs. <br />
<br />
The result is to be displayed in D5 of the current worksheet.<br />
<br />
Help is much appreciated. Thank you very much in advance. <br />
<br />
Regards, Andreas
</div>
</div>


Dear Experts: 

I got thousands of entries in Column A. Part of the string in these entries can be 99-999-99-99 such as ...

P:\\Graphics\\MyFolder\\99\\99-999-99-99.tif

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. 

Regards, Andreas

Count the number of occurrences of a substring in Column A entries using VBA

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.