Using VBA I want to find how many times an occurance of a text string happens.

ie. how many "HPPL" are within B4:G13, it would be nice too if case didn't matter, I may have to test for both though.

Is there a countif in VBA?

Ron