Selecting a target column in vba

[RPM7]

Hi guys, I'm having a little trouble with a bit of code.
I don't really know much vba, and I usually manipulate existing code to do what I need.
This bit of code has me stumped and I can't find anything similar.

At the moment I'm trying to record changes to my worksheet when someone modifies the cells in certain ranges.
The code then tracks the changes in offset cells. What I need is to have these changes recorded in columns, AW, AX, & AY.

Any help on this would be greatly appreciated.

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("C7:H229,K7:M229,P7:R229,U7:W229,Z7:AB229")) Is Nothing Then Exit Sub
Application.EnableEvents = False
With Target
    .Offset(, 46).Value = Date
    .Offset(, 47).Value = Time
    .Offset(, 48).Value = Environ("username")
End With
Application.EnableEvents = True
End Sub

 

[Domenic]

Try...

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("C7:H229,K7:M229,P7:R229,U7:W229,Z7:AB229")) Is Nothing Then Exit Sub
    Application.EnableEvents = False
    With Target
        Range("AW" & .Row).Value = Date
        Range("AX" & .Row).Value = Time
        Range("AY" & .Row).Value = Environ("username")
    End With
    Application.EnableEvents = True
End Sub

 

[RPM7]

Thanks Domenic, that did the job.

 

[Domenic]

You're very welcome!

 

[RPM7]

Sorry to pester you Domenic, but the macro seems to have stopped working all of a sudden.
I'm using it on 2 worksheets and its stopped on both.

I've looked online and found references to enable the events but I'm not sure.
My code says that they're enabled.

It might be worth noting that I have toggle buttons on the same worksheet, but I'm not sure if they have caused an interference.

 

[Domenic]

Did you try running the following line of code in the Immediate Window (Alt+F11 > Ctl+G)...

Application.EnableEvents = True

If so, did you try quitting, and then re-starting Excel?

 

[RPM7]

Brilliant. That's it working now.
Thanks again Domenic.

 

[Domenic]

You're very welcome!