How To Avoid Using Too Many OR and AND Functions In VBA

[Excel Fox]

You could do something like this

If Instr(1,"|2001|2002|2003|2011|2012|2017", "|" & ShD.Cells(C.Row, intYearCol).Value & "|") >0 Then
'Your other code
End if

[flora]

You could do something like this

If Instr(1,"|2001|2002|2003|2011|2012|2017", "|" & ShD.Cells(C.Row, intYearCol).Value & "|") >0 Then
'Your other code
End if

WOW!

Admin you are amazing!

it works.

thanks so much

[flora]

to make it work. i added one extra vertical bracket If Instr(1,"|2001|2002|2003|2011|2012|2017|", "|" & ShD.Cells(C.Row, intYearCol).Value & "|") >0 Then

thanks alot


if this is the one to include

what could be the opposite of this.
for example

i would say exclude "|1998|1995|1992|1978|1983|1977|"

is it something like i use Not or there is another trick for excluding?

thanks Admin