Thread: strings in a range
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default strings in a range
Application.Countif(Range("myRange"),"*string*)

Application.CountA(range("MyRange"))

--
Regards,
Tom Ogilvy


"Peter Morris" <nospam.ple@se wrote in message
. uk...

"Bob Phillips" wrote in message
...
Application.Countif(Range("myRange"),"string")

as an example

--
HTH

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?



Reply With QuoteReply With Quote