Search for string containing
On Thu, 14 Jan 2010 12:25:01 -0800, richzip
wrote:
Hello,
I have the following in VBA:
If .Cells(X, "K") = "RG" Then
.Cells(X, "Q").Value = "TRC"
How can I modify this formula to look in column K for a string that contains
RG and perform the same function? (i.e., if it contains RG-TRVL or TRVL-RG,
then TRC should automatically be placed in column Q)?
Thank you.
Use the InStr function. If it returns a non-zero, your substring is contained
in the string.
--ron
|