PDA

View Full Version : [SOLVED] Range instead of Formula...



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

Bob Phillips
11-28-2008, 07:22 AM
'Unique Call_Type Named Ranges
With Range("Call_Type")
.Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="=" & Range("Drp_Call_Val").Address
End With

georgiboy
11-28-2008, 07:23 AM
With Range("Call_Type")
.Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="=Drp_Call_Val"
End With

khalid79m
11-28-2008, 07:53 AM
whats the difference between your responses?

Bob Phillips
11-28-2008, 08:27 AM
I converted the named range to a range address, the other retains the name itself.