Occurances of value
 

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

Occurances of value
 

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


"Todd Huttenstine" wrote in message
...
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

Occurances of value
 

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



"Trevor Shuttleworth" wrote in message
...
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


"Todd Huttenstine" wrote in message
...
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

Occurances of value
 

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

Regards

Trevor


"Todd Huttenstine" wrote in message
...
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



"Trevor Shuttleworth" wrote in message
...
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


"Todd Huttenstine" wrote in
message
...
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