Excel Date last modified

Microsoft Excel 2007
October 8, 2009 at 08:52:05
Specs: Windows XP
I am trying to get the date of a cell in Column E to update when I modify cells in column F, right now I have (from another forum):

Private Sub Worksheet_Change(ByVal Target As Range)
Range("E" & Target.Row) = Date
End Sub

That's close, and very helpful, but it changes E when I update anything in that row, is there a way to limit it to only update E when I change something in F?


See More: Excel Date last modified

Report •


#1
October 8, 2009 at 09:08:09
Have VBA check the column of the cell (Target) that was changed:

Private Sub Worksheet_Change(ByVal Target As Range)
 If Target.Column = 6 Then _
   Range("E" & Target.Row) = Date
End Sub


Report •

#2
October 9, 2009 at 05:57:39
Thank you so much

Report •

#3
October 9, 2009 at 06:02:28
Anytime.

Report •

Related Solutions


Ask Question