change the Date in cell B2 if changes are made

[Steved]

Hello from Steved

I'm using excel 2007

I would like a formula please to change the date in Cell B2 if I make
changes to the data in the worksheet the range is C2:F550

Thankyou.

 

[Gary''s Student]

Paste the following event macro in the worksheet code area:

Private Sub Worksheet_Change(ByVal Target As Range)
Set r = Range("C2:F550")
If Intersect(r, Target) Is Nothing Then Exit Sub
Application.EnableEvents = False
Range("B2").Value = Date
Application.EnableEvents = True
End Sub

 

[Steved]

Hello Gary from Steved

Firstly Thankyou, Gary I'm only allowed one instance off Worksheet_Change
because if I use 2 or more in the same work sheet I get

"ambiguous name detected:Worksheet_Change"

Can you please think off a solution or is this not possible yes I've already
got one and using your code makes it 2.

Thankyou.