Author Topic: Excel VBA, list of sorted dates from range.  (Read 3934 times)

0 Members and 1 Guest are viewing this topic.

LSElite

  • Newt
  • Posts: 65
Excel VBA, list of sorted dates from range.
« 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
“A life spent making mistakes is not only more honorable, but more useful than a life spent doing nothing.”
― George Bernard Shaw

Matt__W

  • Seagull
  • Posts: 12955
  • I like my water diluted.
Autodesk Expert Elite
Revit Subject Matter Expert (SME)
Owner/FAA sUAS Pilot @ http://skyviz.io

LSElite

  • Newt
  • Posts: 65
Re: Excel VBA, list of sorted dates from range.
« Reply #2 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
“A life spent making mistakes is not only more honorable, but more useful than a life spent doing nothing.”
― George Bernard Shaw