+ Reply to Thread
Results 1 to 3 of 3

Timestamp Formula

  1. 10-06-2010, 07:11 PM #1
    mcmuney
    mcmuney is offline
    Forum Contributor
    Join Date
    07-16-2008
    Location
    USA
    Posts
    142

    Timestamp Formula

    I'd like to specify a timestamp of the last time the file was saved within a cell, is there a formula for this?
    Last edited by mcmuney; 10-06-2010 at 07:41 PM. Reason: Solved.. thanks!
    Reply With QuoteRegister To Reply
  2. 10-06-2010, 07:22 PM #2
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,318

    Re: Timestamp Formula

    I don't know of a formula, but this will work in VBA.

    Place in the ThisWorkbook module.

    Change sheet name and range to suit.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 10-06-2010, 07:26 PM #3
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486

    Re: Timestamp Formula

    A little code in the workbook module would activate when you save the workbook, this will place the date and time in a specified range.
    Please Login or Register  to view this content.
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1