Code:
With wsReview.Range(Cells(9, 20), Cells(9, ic + lastr)).Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _ <---Highlight in yellow
Operator:=xlBetween, Formula1:="Pool" <---Arrow on this line
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
I am receiving a Run-time error '1004': Application-defined or object-defined error
I copied this from a recorded macro then edited the range selection.