Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
timestamp question
hi,
sounds like you are using the formula Now(). don't. use code. in the on close event add this.. sheets(your sheets).select Cells(your timestamp cell).select seletion.value = now() -----Original Message----- Two if the worksheets in my workbook has a cell which I am trying to fill in via code with value Now(). I am using the worksheet_change event to capture a change in the selected worksheet. When I close the workbook I want the date/time stamp on the worksheet that got changed to get updated. All I can accomplish is to get both worksheets date/time stamps to change, or neither date/time stamp to shange. I can watch code skip over the worksheet that did not have a change, but during the execution of the code for the changed worksheet, both worksheets date/time stamps change. Any help would be appreciated. Thanks . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Timestamp | Excel Discussion (Misc queries) | |||
timestamp | Excel Worksheet Functions | |||
Timestamp ? | Excel Discussion (Misc queries) | |||
Timestamp | Excel Discussion (Misc queries) | |||
Timestamp | Excel Discussion (Misc queries) |