+ Reply to Thread
Results 1 to 7 of 7

TimeStamp not working

  1. #1
    Forum Contributor
    Join Date
    11-08-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2016
    Posts
    140

    TimeStamp not working

    Hi,
    I have butchered a tracker that wasn't mine to get a TimeStamp but it isn't working on my tracker. The person that wrote the original tracker isn't available to ask and I can't follow the code to work out what is wrong.
    Originally the location of the time was on the same worksheet that the timestamp was being inserted, I have moved it to a worksheet called 'Validation' which is normally hidden (I have tried it with the sheet visible but still not working).

    I have attached a copy of the tracker.

    Thanking you all in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: TimeStamp not working

    What's it supposed to do, that it's not doing?
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Contributor
    Join Date
    11-08-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2016
    Posts
    140

    Re: TimeStamp not working

    When I use the shortcut CTRL+t it should paste the time into the cell. The time is pulled form G2 on the Validation worksheet. Instead I get a Run-time error '91' message.... "Object variable or With block variable not set".
    I am not aware of anything changing when I copied it and I don't know enough to be able to work out what it is doing to fix it.

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: TimeStamp not working

    There's nothing in G2 of the Validation sheet.

    There's no reference to the Validation sheet at all, in the code.

    When I press Ctrl-t, the current time is entered into the activecell.

    I don't understand / can't replicate the issue.

  5. #5
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: TimeStamp not working

    It would be best to describe what exactly the macro should do. As Olly said, you can't get the time from Sheet "Validation", cell G2, because that cell is empty.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  6. #6
    Forum Contributor
    Join Date
    11-08-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2016
    Posts
    140

    Re: TimeStamp not working

    Apologies to all, I uploaded the incorrect document. Pleae find attached the correct document attached below.
    Attached Files Attached Files

  7. #7
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: TimeStamp not working

    It looks like you've tried to copy a macro from Word to Excel - InsertDateTime is a Word method, it's not valid in Excel.

    What's wrong with simply using Ctrl - Shift - : to insert the current time?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA scripts stop working after TimeStamp is used
    By mowens74 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2019, 05:36 AM
  2. Timestamp with Circular reference & UDF not working properly
    By GAURAVVOHRA in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-31-2019, 09:21 AM
  3. Timestamp with Circular reference & UDF not working properly
    By GAURAVVOHRA in forum Excel General
    Replies: 1
    Last Post: 03-31-2019, 04:30 AM
  4. Replies: 2
    Last Post: 11-09-2016, 02:23 PM
  5. Working with a Timestamp
    By RedSummer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-31-2015, 07:10 PM
  6. When a timestamp doesn't behave as a timestamp
    By mredekopp in forum Excel General
    Replies: 3
    Last Post: 03-07-2011, 03:39 PM

Tags for this Thread

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