View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Find specific text in a string

Note that this won't find "server", since Like is case sensitive unless
Option Compare Text is included in the module.

If you have mixed cases, you could use

LCase(Cells(row, column).Text) Like "*server*"

In article ,
"Bob Phillips" wrote:

Use

Cells(row,column).Value Like "*Server*"