Esmatullah
12-19-2012, 10:03 PM
Hi dear Friends! :help
I need to edit this macro that apply in a range like (B10:B2008) not in active cell :banghead: please help me dear friends.
Public Sub CreateList()
With ActiveCell
.Validation.Delete
.Validation.Add xlValidateList, , , "=" & "A1:A26"
End With
End Sub
I need to edit this macro that apply in a range like (B10:B2008) not in active cell :banghead: please help me dear friends.
Public Sub CreateList()
With ActiveCell
.Validation.Delete
.Validation.Add xlValidateList, , , "=" & "A1:A26"
End With
End Sub