Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Column = 2 Then
.Offset(, -1).Value = Now
End If
End With
End Sub

HTH
--
AP

"Joshua Vista Star" <Joshua Vista [email protected]> a écrit
dans le message de
news:[email protected]...
> -- This one is a toughy!!!!!!!
>
> Goal:
> I have two colums and multiple rows. I would like to updated the first row
> with
> the time that the second row was modified.
>
> Problem:
> When ever the second row is modifed every-time stamp in the first colum is
> updated.
>
> I need to update the time in each row independently - and keep it from
being
> modified or updated.