+ Reply to Thread
Results 1 to 6 of 6

Date and Time Stamp for Last Activity in Range

  1. #1
    Registered User
    Join Date
    11-09-2007
    Posts
    22

    Date and Time Stamp for Last Activity in Range

    I know this is retarded basic, but I'm a VBA noob and trying to create a date/time stamp if anything in columns B:O are changed. This code works great if i wanted to go A:O, but I don't know how to fix it. Thanks for the help.

    Please Login or Register  to view this content.
    Last edited by XLevel; 11-19-2010 at 04:14 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,207

    Re: Date and Time Stamp for Last Activity in Range

    One way:

    Please Login or Register  to view this content.

    Regards
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    11-09-2007
    Posts
    22

    Re: Date and Time Stamp for Last Activity in Range

    Works great! Thank you very much!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,207

    Re: Date and Time Stamp for Last Activity in Range

    You're welcome. Thanks for the feedback.

  5. #5
    Registered User
    Join Date
    11-09-2007
    Posts
    22

    Macro Stopped Working and Macro Not Listed

    I was using this macro, as helped out in this thread. I closed the file and came back to it a while later, but now I cannot figure out how to get it to run. It's not in the list of macros to run and I haven't used my macro skills in so long I don't have a clue what to do.

    This is what I have in Module1

    Please Login or Register  to view this content.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,207

    Re: Date and Time Stamp for Last Activity in Range

    Two reasons it's not in the list of macros to run. 1) it's shown as Private, and 2) more importantly, it requires a parameter to be passed to it.

    The other problem is that you've changed the macro name from Worksheet_Change to DateTimeStamp which will mean nothing to Excel.

    For it to be executed automatically, it needs to be a Worksheet_Change event. And it needs to be in the Worksheet Class Module, not Module1


    Regards

+ 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