Update a Cell and Date/Time Stamp in another

This code checks a column in excel for an update and if it happens then date/time stamps another.

The Code

Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target.Column = 19 Then Target.Range("B1").Value = Now End If End Sub

Code Snippits