TheSwamp

Code Red => VB(A) => Topic started by: LSElite on December 21, 2015, 05:10:33 AM

Title: Excel VBA, list of sorted dates from range.
Post by: LSElite on December 21, 2015, 05:10:33 AM

Hey All

I primarily program in lisp and am really struggling to wrap my head around array functionality.
Anyone have any ideas how to achieve this with VBA?

I need to store all values in a range that are dates and not store any duplicates.
then if possible sort earliest to latest.

Cheers

Title: Re: Excel VBA, list of sorted dates from range.
Post by: Matt__W on December 21, 2015, 06:59:13 AM

Hopefully these will give you something to go on....

http://stackoverflow.com/questions/11870095/vba-remove-duplicates-from-array

http://stackoverflow.com/questions/9404334/how-do-i-put-an-array-of-random-dates-in-chronological-order

Title: Re: Excel VBA, list of sorted dates from range.
Post by: LSElite on December 21, 2015, 08:57:42 AM

Thanks for the links, the info is handy to know.
I found an alternate solution which seems to have gotten me out of trouble for now.
Cheers for the help mate.  :-D