title: Insert date into a range
body: <p>I would need a code to allow me produce the specific date to a range of rows in a column. So far, I only know how to do it using Excel function but I have more than 500 rows thus it would be time consuming to manually make changes. </p>
  
  <p>I would like to insert "4/9/2015" on the date column in column A. The current Excel function that I have done is <code>=Today()</code>.  </p>
  
  <p>Is there any Excel VBA I could use to insert specific dates in a range of rows?</p>