+ Reply to Thread
Results 1 to 6 of 6

Time Stamps Deleting Blank Rows

  1. #1
    Registered User
    Join Date
    03-12-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    51

    Time Stamps Deleting Blank Rows

    Hello,

    I have code to stamp time for entries in the 'AFRsDB' and 'AFRsParts' sheets in column B. Is there a way to alter the code to check to see if the row is blank? I have deleted some rows in the 'AFRsDB' sheet but the time stamps still remain.

    Thank you,
    FF
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,363

    Re: Time Stamps Deleting Blank Rows

    Change your code to:

    Please Login or Register  to view this content.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Registered User
    Join Date
    03-12-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    51

    Re: Time Stamps Deleting Blank Rows

    Thank you for helping. I am sorry I should have mentioned that the rows fill from code. If you go to the AFRsInput sheet and click 'Add New' and put a something in cell D4 and then click 'Update Data' it should post the new record in the 'AFRsDB' sheet and the timestamp should fill in column B.

    Can you see if this is possible please?

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,363

    Re: Time Stamps Deleting Blank Rows

    Why bother?

    Add the timestamp code into the original code.

  5. #5
    Registered User
    Join Date
    03-12-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    51

    Re: Time Stamps Deleting Blank Rows

    oh that is a good idea thanks

  6. #6
    Registered User
    Join Date
    03-12-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    51

    Re: Time Stamps Deleting Blank Rows

    How can this be added please?

    Please Login or Register  to view this content.

+ 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