VBA code to return the number of results derived from Findall

[avshi]

Hi all,
So I made a code that looks for certain values in the file,
and then calling another procedure.
The code works fine but, when I tried to run it on a file where the value I looked for appeared 5000 times
the running time of the code becomes unreasonable.

I thought of making some sort of go-no go rule at the beggining of the code,
Based on search results, or estemating the running time.

Any Ideas of how do I do it?

 

[BrianJN1]

Please, we are not mind readers. Without more information no-one can assess what you require.