I need help with this.

[Ayo]

I keep getting "Application-defined or object-defined error." Any ideas,
please help.

With Range("B3").Validation
.Add Type:=xlValidateList, _
AlertStyle:=xlValidAlertStop, _
Operator:=xlBetween,
Formula1:="=OFFSET(MarketStart,MATCH(B20,Markets,0)-1,1,COUNTIF(Markets,B20),1)"
End With

 

[Blue Max]

Hello Ayo,

Not sure, but aren't you missing an underscore at the end of the fourth line
in order for it to be a continuation of the prior line. Perhaps, this is
generating the indicated error.

Good Luck,

Richard

*************************

 

[Ayo]

No. That happened when I pasted the code in here. line 4 and 5 are actually