title: Excel VBA - How do I find the smallest and largest keys in a dictionary
body: <p>I created a dictionary to grab unique date values as keys, with an integer item, like so:<br>
  -Key,     Item<br>
  -4/27/2017, 1<br>
  -5/4/2017, 56<br>
  -5/31/2017, 103  </p>
  
  <p>I want to create a title that says something like "Report for <em>MINDATE</em> through <em>MAXDATE</em>", so I need to be able to grab the smallest date and the largest date from my dictionary and store them as variables. The integer item will not always necessarily be in ascending order, so I cannot use that.</p>
  
  <p>I tried the following with no luck:  </p>
  
  <pre><code>debug.print worksheetfunction.min(datedict.keys)
  </code></pre>
  
  <p>I don't want to create a loop that checks each key and compares it to the previous one if I don't have to. Is there a quicker and easier way to accomplish what I need?</p>