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
--
justin4480
------------------------------------------------------------------------
justin4480's Profile:
http://www.excelforum.com/member.php...o&userid=34907
View this thread:
http://www.excelforum.com/showthread...hreadid=546465