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
.