I ran into a problem in excel. I was hopingyou can help me. I have this code to enter a timestamp on a cell whenever Iupdate another and its working, but I also want to record a date stamp when Ichange data on another column other than column A. Like if I edit anythingin column C then date stamp adjacent cell in Column D. <o></o>
<o> </o>
<o> </o>
The following code records a date stamp in the adjacent cellin column B when data is entered in column A:<o></o>
<o> </o>
<o> </o>
Private Sub Worksheet_Change(ByVal Target As Range)<o></o>
Dim Cell As Range<o></o>
For Each Cell InTarget<o></o>
With Cell<o></o>
If .Column =Range("A:A").Column Then<o></o>
Cells(.Row,"B").Value = Int(Now)<o></o>
End If<o></o>
End With<o></o>
Next Cell<o></o>
End Sub<o></o>
<o> </o>
I don’t know how to add another (IF and Then) code.<o></o>
<o> </o>
I’d really appreciate if you can help with this.<o></o>
<o> </o>
<o> </o>
The following code records a date stamp in the adjacent cellin column B when data is entered in column A:<o></o>
<o> </o>
<o> </o>
Private Sub Worksheet_Change(ByVal Target As Range)<o></o>
Dim Cell As Range<o></o>
For Each Cell InTarget<o></o>
With Cell<o></o>
If .Column =Range("A:A").Column Then<o></o>
Cells(.Row,"B").Value = Int(Now)<o></o>
End If<o></o>
End With<o></o>
Next Cell<o></o>
End Sub<o></o>
<o> </o>
I don’t know how to add another (IF and Then) code.<o></o>
<o> </o>
I’d really appreciate if you can help with this.<o></o>