N
Nigel
so i have data validation from a range derived from variables as seen
below....
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop,
Operator:= _
xlBetween, Formula1:="=A7:A" &
Range("EndOfProducts").Offset(-1, 0).Row
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = False
so you can see that the range of my validation data is populated by
variables...which is working great...
the problem is...i need to edit it so that my drop down only shows
unique items, and omits any blank cells....
is this possible?
below....
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop,
Operator:= _
xlBetween, Formula1:="=A7:A" &
Range("EndOfProducts").Offset(-1, 0).Row
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = False
so you can see that the range of my validation data is populated by
variables...which is working great...
the problem is...i need to edit it so that my drop down only shows
unique items, and omits any blank cells....
is this possible?