I seem to be having an issue with a Worksheet_Change event. I have it setup to auto-populate a cell (using the offset method) based on a cell change. This works fine unless a user changes the value in a cell and mouse clicks to another row. When that occurs, if the column to which they move the cursor is within my bounds, it changes that row instead of the original.

Private Sub Worksheet_Change(ByVal Target As Range)
    If ActiveCell.Column = 8 Then
        ActiveCell.Offset(0, 5) = Now()
    ElseIf ActiveCell.Column = 14 Then
        ActiveCell.Offset(0, -1) = Now()
    ElseIf ActiveCell.Column = 15 Then
        ActiveCell.Offset(0, -2) = Now()
    ElseIf ActiveCell.Column = 16 Then
        ActiveCell.Offset(0, -3) = Now()
    End If
End Sub
What I need is a method by which I can reference the cell that was originally changed and perform my offset based on that value. Any ideas as to how I can store that original cell value would be most appreciated.