Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date does not update until worksheet change
Hi,
My work sheet has a date in cell: "A1". I would like the date to update (only) if there is a change in the sheet. I'm thinking of this to start: Something like Private Sub Workbook_SheetChange(By Val Sh As Object, By Val_ Target As Excel.Range) Thanks in advance, Amy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Date Cell when any of target cells change | Excel Worksheet Functions | |||
change the name of a worksheet/update VBA code | Excel Discussion (Misc queries) | |||
Update date field upon cell range change | Excel Worksheet Functions | |||
How to prevent file date change when no update made in Excel? | Excel Discussion (Misc queries) | |||
How do I get one worksheet to update when others change? | Excel Worksheet Functions |