strings in a range

  • Thread starter Thread starter Peter Morris
  • Start date Start date
P

Peter Morris

what's a function I can use in VB to count the
number of times a particular string occurs in
a named range of cells?
 
Application.Countif(Range("myRange"),"string")

as an example

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Bob Phillips said:
Application.Countif(Range("myRange"),"string")

as an example
Click to expand...

That works.

also, is it possible to use wildcards in the search string?

Or to count the number of cells in the range with ANY
text in?
 
Application.Countif(Range("myRange"),"*string*)

Application.CountA(range("MyRange"))
 
Tom Ogilvy said:
Application.Countif(Range("myRange"),"*string*)

Application.CountA(range("MyRange"))
Click to expand...

Brilliant, much gratitude to both of you.
 
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

A find formul looking at two named ranges for two strings 6
counting no. of times a character occurs in a cell 3
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Use CountIf for a literal string 3
Set non-continuous PrintArea via Function / Name 0
Countif formula perhaps 7
Delete rows based on contents of Col A 0
Counting the number of occurrences... 2

Back
Top