Results 1 to 7 of 7

Vba to select rows based on date and Delete

Threaded View

Wither125 Vba to select rows based on... 06-28-2016, 04:44 PM
PCI Re: Vba to select rows based... 06-28-2016, 05:03 PM
Wither125 Re: Vba to select rows based... 06-29-2016, 04:13 PM
PCI Re: Vba to select rows based... 06-30-2016, 08:03 AM
Wither125 Re: Vba to select rows based... 06-30-2016, 04:12 PM
PCI Re: Vba to select rows based... 07-01-2016, 04:30 AM
Wither125 Re: Vba to select rows based... 07-03-2016, 11:48 AM
  1. #1
    Registered User
    Join Date
    05-16-2016
    Location
    bangalore,India
    MS-Off Ver
    2013
    Posts
    32

    Vba to select rows based on date and Delete

    Hello,

    I want to delete the rows which are not <=8 days and >=8 days.

    for ex: lets take today's date 29/06/2016. So now select the rows that is not <= 8 days and >8 days from 29/06/2016 on wards.
    and delete the rows who's dates are not <=8 days and >8 days.

    Below is pic.

    date.PNG

    Thank You!

    Regards
    Wither
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to delete rows based on date
    By BillDoor in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-21-2015, 10:28 AM
  2. Select multiple rows and cells based on a single date
    By UTLee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2013, 11:09 AM
  3. how to select (or delete) rows based on column time
    By sserafini in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-06-2010, 03:01 AM
  4. Delete rows based on date
    By randell.graybill in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-09-2009, 01:44 AM
  5. Delete rows based on date
    By mattbrem in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-06-2009, 12:22 PM
  6. Select rows in table based on start and end date
    By packe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2007, 12:18 PM
  7. Select and Delete Rows Based on Various Possibilities in First Cell
    By notdave in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2005, 11:40 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