VBA: select unique dates out a range

[BIGTONE559]

Greetings,

i need help with selecting unique dates from a range of cells. e.g. Cells Range("A1:A30") contain dates. however in cells Range("B1") i'd like to begin a list from that range of unique date values within that range.

all help is appreciated

 

[Andrew Poulsom]

You can use Advanced Filter:

http://www.contextures.com/xladvfilter01.html#FilterUR

 

[BIGTONE559]

You can use Advanced Filter:

http://www.contextures.com/xladvfilter01.html#FilterUR

Thanks for the response andrew,

i've actually seen the advanced filter (Contextures example). however, i was trying to accomplish this through simple code. the unique list would never exceed 7 days (shouldn't) so it wouldn't be a large collection of data. are you aware of a simple way of doing this via VBA?

 

[Andrew Poulsom]

If you record a macro while filtering manually you will get the VBA code that you want.