I have a folder with 518 files, I need to count the number
of times "KKL" occurs in a range called "rng1" and then
return the value to cell A2 in a new book.

Is this possible?

I don't fancy having to do it all manually.

Thanks in advance.

Gareth