Newbie Question, NOW() function

J

justin4480

I have created a simple macro that creates a time stamp on a specific
cell using the NOW() function. It works perfectly, but resets the
time/date each time I open the document.

Any help would be greatly appreciated.


Code Below:

Sub Time_Stamp()
'
' Time_Stamp Macro
'
Range("B11").Select
ActiveCell.FormulaR1C1 = "=NOW()"
Range("B12").Select

End Sub
 
P

Paul B

Justin4480, try this

Sub Time_Stamp()
'
' Time_Stamp Macro
'
Range("B11") = Now

End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
P

Paul B

Your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top