Author Topic: Excel VBA, list of sorted dates from range.  (Read 1017 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: 12915
  • I like my water diluted.
Autodesk Expert Elite
Autodesk Revit Architecture, Structure, MEP Mechanical and MEP Electrical Certified Professional
Building Performance Analysis Certified (BPAC v3.0)
Autodesk Navisworks 2014 Essentials

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