Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change the Date in cell B2 if changes are made
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change the Date in cell B2 if changes are made
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change the Date in cell B2 if changes are made
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. "Gary''s Student" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color a cell When Change Is Made | Excel Discussion (Misc queries) | |||
How to prevent file date change when no update made in Excel? | Excel Discussion (Misc queries) | |||
what made my columns change from a b c to 1 2 3 ? Rows are 1 2 3 a | Excel Discussion (Misc queries) | |||
how do I take the changes I made on one page and change all pages | Excel Discussion (Misc queries) | |||
I want a mesage sent when a change is made to an excel file | Excel Discussion (Misc queries) |