If for word in sentence
Absolutely perfect Paul, works fine and is nice and tidy. Many thanks.
Graham
Paul C wrote:
Try this (assuming A14 would not start with "Information:" when there is the
extra phrase)
If Left(Range("A14"),11)=" Information" Then
Do Something
Else
Do Something Else
End if
|