khalid79m
11-28-2008, 07:06 AM
:think: Im new to Named Ranges
my working formula
'Unique Call_Type Named Ranges
With Range("Call_Type")
.Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="=$IV$3:$IV$500"
End With
i need to change the formula1:="=$IV$3:$IV$500" to range "Drp_Call_Val"
can this be done ??? or do I have to stick with a formula
my working formula
'Unique Call_Type Named Ranges
With Range("Call_Type")
.Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="=$IV$3:$IV$500"
End With
i need to change the formula1:="=$IV$3:$IV$500" to range "Drp_Call_Val"
can this be done ??? or do I have to stick with a formula