Contains Function in a Macro (Excel 2007)

Topic

New Reply

Hi,
I’m trying to write a bit of code that says if L1 “contains” the letters “Sett-Batch”, then cell E1 would result as “ACH” (see code below). Clearly my word “contains” in the code below doesn’t work, and I figured it wouldn’t, but I didn’t know how to go about the contains function as I normally always go with =. Any help is appreciated as always!
Thanks!
Lana

If Sheet3.Range(“L” & x) contains “Sett-Batch” Then
Sheet3.Range(“E” & x) = “ACH”

Reply | Quote

Replies

Try this:

If Sheet3.Range("L" & x) Like "*Sett-Batch*" Then

or this:

If InStr(Sheet3.Range("L" & x), "Sett-Batch") > 0 Then

Reply | Quote

Works perfect!
Thanks Hans!
Lana

Reply | Quote