title: VBA get the last day of the month
body: <p>I am  pretty new to VBA. I have a range of dates and I need to write a code that will change the date in the cell to the last day of the month, used in a cell. 
  For example, if the date in the cell is <code>28/03/2018</code> I want it to be replaced by <code>31/03/2018</code>. Any idea how I can do that?</p>