Newbie Question, NOW() function

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, 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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

Perfect.

Thanks Paul

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

"justin4480" <[email protected]> wrote
in message news:[email protected]...
>
> Perfect.
>
> Thanks Paul
>
>
> --
> justin4480
> ------------------------------------------------------------------------
> justin4480's Profile:
http://www.excelforum.com/member.php...o&userid=34907
> View this thread: http://www.excelforum.com/showthread...hreadid=546465
>