VBA code to put timestamp into cells in a column

[traub86]

I'm looking to put a timestamp into "G7" when I click a button and then every time I click that same button it puts a timestamp into the next cell in that column (i.e. G8, G9, G10, etc.).

 

[steve the fish]

Try this:

Cells(Application.Max(7, Range("G" & Rows.Count).End(xlUp).Row + 1), "G").Value = Now

 

[traub86]

Awesome. Works perfectly. Thanks for the help!!!