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

--
Gary''s Student - gsnu200768


"Steved" wrote:

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.