Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation
Hi Trev
You can use Advanced Filtering to produce a unique items list, or you could use the following code that produces a collection of unique items (it uses the value in the cell as the key in the collection.Add method with an On Error Resume Next which means if that key already exists ie it's a duplicate, then the code skips over to the next cell). Sub test() Dim coll As New Collection, c As Range, i As Long With Sheets("Info") On Error Resume Next For Each c In .Range("A1:A" & .Range("A65536").End(xlUp).Row) coll.Add c.Value, c.Value Next c End With On Error GoTo 0 For i = 1 To coll.Count Debug.Print coll(i) Next End Sub Give it whirl! I hope it helps! Richard Trever B wrote: Hi, Thanks in advance Need to create a list from a worksheet "Info" Column A Problem is lots of repeats. I would like just every diferent entry (No Repeats) Hope you can help. Don't no where to start Thanks Trev |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Programming | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |