+ Reply to Thread
Results 1 to 4 of 4

Automatic Date Update on Row Change, Issue with Blank and Deleted Rows

  1. #1
    Registered User
    Join Date
    04-08-2015
    Location
    America
    MS-Off Ver
    Office 2013
    Posts
    29

    Automatic Date Update on Row Change, Issue with Blank and Deleted Rows

    Hi,
    I have this macro:

    Please Login or Register  to view this content.
    This macro updates the date in the current row I change a value in. I am using this to track spreadsheet usage.
    The issue I want to overcome is that when I want to delete a particular row of data, the date value remains and continues to update.
    I am unsure how to possible alter the code to not insert the date value if the row has no data, or maybe there is a more elegant solution.

    Cheers for any help.
    Last edited by nKife; 05-13-2015 at 09:51 PM.

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Automatic Date Update on Row Change, Issue with Blank and Deleted Rows

    Hi nKife,

    Try this:

    Please Login or Register  to view this content.
    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  3. #3
    Registered User
    Join Date
    04-08-2015
    Location
    America
    MS-Off Ver
    Office 2013
    Posts
    29

    Re: Automatic Date Update on Row Change, Issue with Blank and Deleted Rows

    Robert,
    Thank you for your help this is the perfect solution.

    Cheers,
    nKife

  4. #4
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Automatic Date Update on Row Change, Issue with Blank and Deleted Rows

    You're welcome

    Thanks for marking the thread as solved and for the rep

    Regards,

    Robert

+ 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. Automatic Change Log Issue
    By bigmantitus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2013, 10:49 AM
  2. Automatic date update
    By Onesock in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-29-2012, 05:33 PM
  3. [SOLVED] Automatic Date Update/Change
    By *C* in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-27-2012, 02:59 PM
  4. Replies: 3
    Last Post: 06-30-2012, 10:38 AM
  5. Insert Blank rows after every date change
    By josigrozi in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-15-2011, 07:23 AM

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