Newbie Question, NOW() function

[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

 

[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

 

[justin4480]

Perfect.

Thanks Paul

 

[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