+ Reply to Thread
Results 1 to 2 of 2

Date edited in next cell

  1. #1
    Registered User
    Join Date
    11-02-2006
    Posts
    7

    Date edited in next cell

    I would like to indicate the date a cell was first used or last edited. I would like to show this date/time in the next cell.

  2. #2
    Forum Contributor
    Join Date
    11-29-2003
    Posts
    1,203
    You can use the code below.

    Please Login or Register  to view this content.
    Need to restrict which cells it acts on (in this case, I made it act only if a change is made in column 4 = column D). Otherwise, the act of writing the date in the next cell is also a "change", which will cause the macro to "fire" again, and again, putting the date in every column on that row.

+ 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