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.

  Dim Cnt As Long
  Dim Rng As Range
  
    Set Rng = Worksheets("Sheet1").Range("B4:G13")
    Cnt = Application.WorksheetFunction.CountIf(Rng, "HPPL")

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