View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default Updating Time when a field has been modified

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 a écrit
dans le message de
...
-- 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.