Thread: If for word in sentence
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Graham H Graham H is offline
external usenet poster
  
Posts: 56
Default If for word in sentence
Many thanks for your help Rick

Graham

Rick Rothstein wrote:
You can count how many lines begin with "Information" using this...

InfoCount = WorksheetFunction.CountIf(Range("A1:A14"), "Information*")

Reply With QuoteReply With Quote