Results 1 to 6 of 6

Display the date and time each time the data in a cell range is changed

Threaded View

  1. #1
    Registered User
    Join Date
    08-22-2012
    Location
    Namibia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Display the date and time each time the data in a cell range is changed

    I'm not familiar with macro's, but found one which accomplishes to change the date and time each time a cell in a column range is changed.

    UDF:
    Public Function UDF_Date(ByVal data) As Date
    UDF_Date = Now()
    End Function
    Formula above range:
    =UDF_Date(H7:H25)

    Example:
    H4 23/08/2012 09:00

    H7 12
    H8 40
    ...
    ...
    H25 15

    If any entry is made in cells H7 - H25, the date and time should be logged in cell H4.

    However, when I open the excel sheet and enable macros it automatically changes the date and time to the date time the sheet is accessed. This also happens when I send the sheet via e-mail and the person on the other side opens it.

    How can I correct this and embed the date with it only changing if one of the cells in the range changes?

    Thank you
    Last edited by Cutter; 08-24-2012 at 12:31 PM. Reason: Added code tags

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