I am fairly inexperienced using Excel, and am seeking some assistance finding the right code for a date stamp issue.
I would like to be able to have the current date inserted into a specific column when any of the cells between column A to I in that row are changed.
I would like the cell in column J to have the current date inserted when the any cells in columns A to I are changed within the same row. At the moment I have managed to have a date stamp inserted into the relevant row of column J when I enter/modify contents of cells in column A, using the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("a:a")) Is Nothing Then
Target.Offset(0, 9) = Date
End If
End Sub
If anyone knows what code I should be using to have the date stamp in the same column but enable this to happen when ANY cell in the same row between column A and I are modified, that would be fantastic.
Bookmarks