unique data validation drop down

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?
 
P

paul.robinson

Hi
Try Google this newsgroup with your question. Skip blanks is a
Validation option, so there should be a method for it. There is no
"unique Items" option in validation.
regards
Paul
 
N

Nigel

the ignore blanks doesn't ignore displaying them in the drop down, it
ignores them when validating the cell...

there should be a way with VBA to accomplish both things....
it seems weird that it wouldn't be built in....what use is a drop down
if it displaying duplicates?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top