change the Date in cell B2 if changes are made

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steved - 07 Feb 2008 22:57 GMT

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.

Reply to this Message

Gary''s Student - 07 Feb 2008 23:24 GMT

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

Signature

Gary''s Student - gsnu200768

> Hello from Steved
>
[quoted text clipped - 4 lines]
>
> Thankyou.

Reply to this Message

Steved - 07 Feb 2008 23:55 GMT

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.

> Paste the following event macro in the worksheet code area:
>
[quoted text clipped - 14 lines]
> >
> > Thankyou.

Reply to this Message