title: Excel macro, add date by button in next row
body: <p>I got problem with adding date button in excel document. I wanted to speed up adding date in document just by clicking the button attached to first row. It works almost fine, adding extra cell with date in next row. But when the hour change, all earlier entries change as well. How should I modify it?</p>
  
  <pre><code>    Sub Makro1()
  '
  ' Makro1 Makro
  '
  
  '
      Cells(Rows.Count, "B").End(xlUp).Offset(1).Select
      ActiveCell.Formula = "=NOW()"
  
  
  End Sub
  </code></pre>