Code to Ignore Certain Cases in a Looping Function

[adambush4242]

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

 

[barnabel]

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

 

[adambush4242]

Peter,

Thank you very much for your help. I thought for some reason I had to list
the strings to exclude, not to include.

Thanks Again,

Adam Bush

 

[Rick Rothstein \(MVP - VB\)]

If I am not mistaken, your suggested If-Then statement can be replaced by
this one...

If Not Instrument$ Like "SPX[!Z]*" Then

Rick

 

[barnabel]

Quite true but I don't want to have to teach and debug somebody else's
regular expressions if they don't know what they are.

If I am not mistaken, your suggested If-Then statement can be replaced by
this one...

If Not Instrument$ Like "SPX[!Z]*" Then

Rick

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