+ Reply to Thread
Results 1 to 6 of 6

Time Stamps Deleting Blank Rows

  1. #1
    Forum Contributor
    Join Date
    03-12-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    421

    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

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

    Re: Time Stamps Deleting Blank Rows

    Change your code to:

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Contributor
    Join Date
    03-12-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    421

    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
    8,448

    Re: Time Stamps Deleting Blank Rows

    Why bother?

    Add the timestamp code into the original code.

  5. #5
    Forum Contributor
    Join Date
    03-12-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    421

    Re: Time Stamps Deleting Blank Rows

    oh that is a good idea thanks

  6. #6
    Forum Contributor
    Join Date
    03-12-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    421

    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)

Similar Threads

  1. Create a Time Range off Time Stamps, and Count Intersecting values
    By athyeh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2014, 05:07 PM
  2. Changing code from deleting rows to cut/paste rows into another sheet and delete blank row
    By kmarshall6576 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2013, 01:54 AM
  3. Deleting Blank Rows
    By agsankaa in forum Excel General
    Replies: 2
    Last Post: 11-06-2008, 11:14 AM
  4. Deleting blank rows on a Mac
    By mister88948 in forum Excel General
    Replies: 0
    Last Post: 11-03-2008, 01:15 PM
  5. Deleting Blank Rows
    By graeme86 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2007, 07:53 AM
  6. Deleting Blank Rows
    By MWS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2005, 02:40 PM
  7. Deleting blank rows
    By Alan M in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2005, 10:06 AM
  8. [SOLVED] Deleting blank rows
    By Michael Chang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2005, 11:06 PM

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