|First, please take a moment to click on the blue line at the bottom of this post and read the instructions on how to post VBA code in this forum so that it is easier for us to read.|
Range("A" & Rows.Count).End(xlUp).Offset(1).Value = Now
Obviously a macro with a single line of code is not that hard to read, but longer macros benefit by having the indents retained when posted.
As for your question, this syntax determines the next empty cell Column A:
Range("A" & Rows.Count).End(xlUp).Offset(1)
If you simply replace that with ActiveCell, the code will put the timestamp in the active cell.
ActiveCell.Value = Now
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03