You don't say which 4th letter you want to keep so I am putting in Z

If Left$(Instrument$, 3) < "SPX" or left$(Instrument$,4) = "SPXZ" Then

Peter Richardson

" wrote:

I had a VBA expert create a program for me, and it has worked perfectly for
months. However, recently I found there was an error because at a certain
point the program excludes certain inputs that meet a certain criteria. The
exact code is:
If Left$(Instrument$, 3) < "SPX" Then
The problem is there is one scenario where the instrument starts with "SPX"
but I don't want to exclude it. There are twelve different strings that
might start with SPX, is there anyway to specify the first four letters, and
exclude SPXJ, SPXK, SPXG, SPXH, etc? I tried listing all these scenarios
where "SPX" currently is and putting "or" between them, but I keep getting
errors. ANy ideas?

Thanks

Adam Bush