Results 1 to 2 of 2

Thread: Excel Macro for Cell LastModified

  1. Jan 27th, 2000, 03:26 AM #1
    mytamagotchi
    mytamagotchi is offline

    Thread Starter
    New Member
    Join Date
    Jan 2000
    Posts
    1

    Post

    Hey all
    I have a cell which needs to put a time stamp to keep track of the last modified.
    Any ideas??

    Thanks a lot
    Reply With Quote Reply With Quote
  2. Jan 27th, 2000, 04:03 AM #2
    spyder
    spyder is offline
    Member
    Join Date
    Oct 1999
    Posts
    50

    Post

    Try this:

    Dim myString
    Set myString = Date$
    ActiveCell.insert myString

    Your Macro Should Set the active Cell that you want the Date to be on
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width