title: VBA to write each day between a data range in Excel
body: <p>I need to make a form in Excel that asks for a start and end date.  Then, I need to write a VBA script that writes out each day within that range in the first blank cell in column A.</p>
  
  <p>So, for example, if it was given:</p>
  
  <pre><code>Start Date: 1/5/2017
  End Date: 1/9/2017
  </code></pre>
  
  <p>The Result would be:</p>
  
  <pre><code>1/5/2017
  1/6/2017
  1/7/2017
  1/8/2017
  1/9/2017
  </code></pre>
  
  <p>Then if it is run again with a new date range, the dates would append to the bottom of the list.  This is just a short example, in practice the date ranges would be much larger and consist of several months.</p>
  
  <p>I'm not really sure where to begin with this, so any help would be greatly appreciated!</p>