Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here's my dilemma...
I have 37 different worksheets (one for each major principal in my company) that are to be updated on a semi-regular basis. I would like for each of these worksheets to have its own time/date stamp that automatically updates itself to the current date and time whenever a change is made on the worksheet. The time/date stamp on one sheet must be independent of the time/date stamps on all other sheets. In other words, when the time and date is updated on one sheet none of the other time/date stamps on the other sheets change unless they are modified as well. I have tried using SendKeys...I thought I had something, but it seemed too complicated to get it to work. And I've also tried using the Worksheet_Change event...I've been tinkering with this code: Private Sub Worksheet_Change(ByVal Target As Range) 'THIS SUB UPDATES THE DATE/TIME STAMP WHENEVER A CHANGE IS MADE TO A PRINCIPAL'S SHEET 'Update "Date" cell Dim Cell As Range For Each Cell In Target With Cell If .Column = Range("B:B").Column Then Cells(.Row, "F").Value = Int(now) End If End With Next Cell End Sub Can someone please advise? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date-time stamp | Excel Discussion (Misc queries) | |||
Time/Date Stamp | Excel Programming | |||
Comparing 2 files on date/time stamp, and based time difference do a subroutine | Excel Programming | |||
Date-Time Stamp | Excel Discussion (Misc queries) | |||
Date/time Stamp? | Excel Programming |