VBA Concatenate Date and Time

  • Hi All,


    I could really use some help to solve an issue I am having.


    I am working on two macros to Concatenate Date and Time and I am having trouble getting either to function correctly.


    Please review attached workbook with notes in the macro.


    Any help would be greatly appreciated.


    Combine Date Time.xlsm

  • Hello,


    In order to add Date and Time ... you can simply add them = Date + Time


    Sadly, in your sample file, there is no indication of your expected result ... even if you type it in manually ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Thanks Carmin.


    The expected result comes from the final bit of code that combines all the row cells into one cell.


    All the results should read like the result in H2 Date & Time|Data|Data|Date & Time

  • Hello again,


    You could test the following macro


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Glad to hear you could fix your problem :)


    Thanks for your Thanks

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)