is it possible to create a data Validation List from a Case Selection
ie
I'm struggling with this oneWith Range("E9").Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="= Case X" 'the X comes from Case Dim SectorType As Integer Worksheets("Input").Select SectorType = Range("T34").Value Select Case SectorType Case 1 = "='WORKSHEET#1'!$A$8:$J$8" Case 2 = "='WORKSHEET#2!$A$8:$J$8" End Select