Occurances of value

T

Todd Huttenstine

Hey guys

I have values in range K40:K90. The variable called
FndVal = "dog".

Using the find function, how do I determine the number of
occurances "dog" is found within this range?


Todd
 
T

Trevor Shuttleworth

Todd

one suggestion:

Sub test()
' the best function would be: =COUNTIF(K40:K90,"dog")
Dim FndVal As String
Dim DogCount As String
FndVal = "dog"
MsgBox WorksheetFunction.CountIf(Range("K40:K90"), FndVal)
' or
MsgBox WorksheetFunction.CountIf(Range("K40:K90"), "dog")
End Sub

Regards

Trevor
 
T

Todd Huttenstine

Thanks

I do not believe I have ever had the need to use the countif function before
in code, and I dont recall ever using it in a spreadhseet as a function
either. I knew it seemed like an easy task. Thanks for your help.


Todd
 
T

Trevor Shuttleworth

You're welcome. Hope it has given you the answer you needed.

Regards

Trevor
 
Top