Hello reader,
I am trying to code an Excel spreadsheet to place a date stamp in column A at any point that particular row is modified - not just the spreadsheet, but every cell in the individual row. I track laptops in the company I work in and to make sure we have accurate data, I need time/date stamps on every row in case that the spreadsheet does not show correct information. Here is the VB code that I have so far:
Option Explicit
---------------------------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Application.EnableEvents = False
Target.Offset.Offset(0, 1) = Now()
Application.EnableEvents = True
End If
End Sub
I am able to get the column to stamp the date and time, but only for 1 column.
Can anyone help me? I am close, I just need a little nudge.
Thanks in advance.
-Rob
