Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula for Cases=144 * # of Cases + Pieces | Excel Discussion (Misc queries) | |||
Calling macros, looping function? Can this code be written more efficiently? | Excel Programming | |||
Change looping process to ignore certain sheets | Excel Programming | |||
GCD Function doesn't work in some cases | Excel Worksheet Functions | |||
Code looping when it should not | Excel Programming |