+ Reply to Thread
Results 1 to 4 of 4

Newbie Question, NOW() function

  1. #1
    Registered User
    Join Date
    05-29-2006
    Posts
    3

    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

  2. #2
    Paul B
    Guest

    Re: Newbie Question, NOW() function

    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" <justin4480.28ksca_1148916902.2411@excelforum-nospam.com> wrote
    in message news:justin4480.28ksca_1148916902.2411@excelforum-nospam.com...
    >
    > 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
    >




  3. #3
    Registered User
    Join Date
    05-29-2006
    Posts
    3
    Perfect.

    Thanks Paul

  4. #4
    Paul B
    Guest

    Re: Newbie Question, NOW() function

    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" <justin4480.28kthz_1148918402.7412@excelforum-nospam.com> wrote
    in message news:justin4480.28kthz_1148918402.7412@excelforum-nospam.com...
    >
    > 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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1