VBA Code Assistance - Update Date in a Cell if Value of Another Cell Changes

[Zedrick13]

Hi Guys,

Can you please help me figure out why the code below doesn't seem to work for MS Excel for Office 365? Thanks in advance!

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("G:G")) Is Nothing Then
   Range("J" & Target.Row).Value = Now
End If
End Sub

Zed

 

[My Aswer Is This]

So if you manually enter a value in column G you want the current date and time entered in Column J

So it works for me.

So are you saying when you manually enter a value in column G nothing happens?

 

[Zedrick13]

I see. I got the ranges interchanged. Thanks!

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

I see. I got the ranges interchanged. Thanks!

 

[Zedrick13]

I sure will. Thanks again.