(Solved) – Automatically adding timestamp to each column


so i have a sheet and whenever something in the range of A10:A23 is changed/updated, it is supposed to put a timestamp in the according column in Row B, however it isnt working and i have no idea why.

I already set the sheets code to “Worksheet” and “change”

Here is my code:

Private Sub Worksheet_Change(ByVal Target As Range)

 If Target.Row = A And Target.Column >= 10 And Target.Column <= 23 Then

        Cells(Target.Column, B) = Now()

    End If

End Sub```

Thanks in advance!

Leave a Reply

Your email address will not be published. Required fields are marked *