Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is this possible???
specialmerchants = InStr(1, mername, m(0) Or m(1) Or m(2) Or m(3) Or
m(4) Or m(5) Or m(6) Or m(7)) if specialmerchants = true then... Obviously this doesn't work but you can see what I'm trying to do, is there a way to make it work? Thanks, Peter |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is this possible???
It's alright the solution is:
specialmerchants = InStr(1, mername, m(0)) Or InStr(1, mername, m(1)) Or InStr(1, mername, m(2)) Or InStr(1, mername, m(3)) Or InStr(1, mername, m(4)) Or InStr(1, mername, m(5)) Or InStr(1, mername, m(6)) Or InStr(1, mername, m(7)) If specialmerchants = True Then .... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is this possible???
If Not(IsError(Application.Match(mername,m,0))) Then
... -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Peter" wrote in message oups.com... specialmerchants = InStr(1, mername, m(0) Or m(1) Or m(2) Or m(3) Or m(4) Or m(5) Or m(6) Or m(7)) if specialmerchants = true then... Obviously this doesn't work but you can see what I'm trying to do, is there a way to make it work? Thanks, Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|