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