Find in range

[slinger1010]

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

[Leith Ross]

Hello Ron,

You can envoke most of Excel's worksheet functions trough Excel. CountIf is one of them.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[slinger1010]

Thank you very much, I have finished my sheet!!!

One more thing I woudn't mind adding as a nice touch, is there a way to find out if the worksheet has been printed?

Ron