Thread: strings in a range
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Peter Morris Peter Morris is offline
external usenet poster
  
Posts: 13
Default strings in a range

"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