+ Reply to Thread
Results 1 to 2 of 2

Time Macro

  1. #1
    Registered User
    Join Date
    04-30-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Exclamation Time Macro

    I am not very good at writing macros and would appreciate some help. I have a list of times (ie. 1:30 PM) in Column A. I need a macro that can delete the rows with times that do not fall within the time ranges set in Cells B9 and B10. For example, I would put 1:00 PM in B9 and 3:00 PM in B10, press a button, and any time ranges in A10:A1000 that do not fall within those times will have their entire rows deleted. I don't want any rows deleted above A10. I have information in those cells that need to stay put. Thanks for reading and I am looking forward to reading any suggestions of code.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: Time Macro

    Might be worth posting a sample workbook. If you have headings in row 9, it may be possible to do this with a filter.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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