| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unique data validation drop down
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation using Unique Values | Excel Discussion (Misc queries) | |||
| Unique entry - Data Validation | Excel Discussion (Misc queries) | |||
| Unique Data Validation | Excel Programming | |||
| Data Validation dependant and unique | Excel Worksheet Functions | |||
| Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
![Nigel[_27_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
