ExcelBanter - I need help with this.

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - I need help with this. (https://www.excelbanter.com/excel-programming/441388-i-need-help.html)

Ayo

I need help with this.

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

All times are GMT +1. The time now is 06:29 AM.