Occurances of value

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
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
 
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
 
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
 
You're welcome. Hope it has given you the answer you needed.

Regards

Trevor
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Collection Variable 4
Counting number of times each unique entry is there 7
Instr() with multiple search terms 4
Match Code 4
Delete matching value along with other cells 1
Top 5 most recurrent values in range. 8
Range passed to a function - trying to just move through the range 4
Retrieving a Collection Item 2

Back
Top