Seeking Help with an Event Handler Function

[USNA91]

Hello, again...

So I have my workbook with 30+ sheets. Each sheet has the following code in it:

CURRENT CODE

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("C7:L159")) Is Nothing Then
Range("C4").Value = Now
End If

End Sub

USER NEED

This code waits for any changes made in the cell range C7:L159 on that sheet, and when it detects such a change it drops the current date and time into cell C4 on that sheet. This function needs to be unique to each sheet. Simple enough.

PROBLEM

It works perfectly on one sheet, but throws errors on the others. Am I running afoul of an activation call or something?

Thanks.

 

[Domenic]

That's great, glad you have a solution for your problem.

Cheers!