Thread: strings in a range
View Single Post
  #5   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

"Tom Ogilvy" wrote in message
...
Application.Countif(Range("myRange"),"*string*)

Application.CountA(range("MyRange"))

--
Regards,
Tom Ogilvy


Brilliant, much gratitude to both of you.


Reply With QuoteReply With Quote