+ Reply to Thread
Results 1 to 4 of 4

Delete Rows Outside of Time Parameters

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Delete Rows Outside of Time Parameters

    On the attached example I have a Command Button that when I press it I want some code in there to run down column A and delete any rows where the time is either before "Settings!C3" or after "Settings!C4".

    Thanks for any help!

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Delete Rows Outside of Time Parameters

    IMPORTANT: You are going to need to make sure the format in column A on the "Fixture" Sheet is the EXACT same as the format in column C on the "Settings" Sheet

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Delete Rows Outside of Time Parameters

    Try the attached.

  4. #4
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Re: Delete Rows Outside of Time Parameters

    Thanks guys.

    stnkynts - I follow your example pretty well and when I change the format of the cells in 'Settings' to match column A in 'Fixture List' it works well. With one exception... I don't want to delete the 'date headers' (highlighted in yellow). Can we add/alter the code to not do this?

    Thanks,
    Adam.

+ 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. Macro to delete certain columns and delete rows based on time in another column
    By beepbeep27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2012, 11:47 AM
  2. delete rows with time function
    By pani_hcu in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-20-2011, 01:16 PM
  3. Delete rows if time is in the AM
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-11-2011, 04:41 PM
  4. Delete two rows at a time
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2009, 10:50 AM
  5. how to delete rows according the special time?
    By jollycarrier in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-03-2006, 05:15 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