Author Topic: Excel VBA, list of sorted dates from range.  (Read 1653 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: 12954
  • 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