+ Reply to Thread
Results 1 to 8 of 8

delete row based on criteria - help!

Hybrid View

  1. #1
    Registered User
    Join Date
    03-14-2014
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: delete row based on criteria - help!

    ... anyone....

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: delete row based on criteria - help!

    Try this approach:

    Sub pinky24zz()
    Range("E1:E" & Range("E" & Rows.count).End(3)(1).Row).AutoFilter 1, "=*review*", xlOr, "=*audit*"
    Range("E2:E" & Range("E" & Rows.count).End(3)(1).Row).SpecialCells(xlCellTypeVisible).EntireRow.Delete
    ActiveSheet.AutoFilterMode = False
    Range("E1:E" & Range("E" & Rows.count).End(3)(1).Row).AutoFilter 1, "=*project*", xlOr, "=*done*"
    Range("E2:E" & Range("E" & Rows.count).End(3)(1).Row).SpecialCells(xlCellTypeVisible).EntireRow.Delete
    ActiveSheet.AutoFilterMode = False
    End Sub

+ 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. Delete Row based on Criteria!!
    By vignesh rocks in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-12-2012, 07:30 AM
  2. Delete row based on criteria
    By D_N_L in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2011, 10:00 AM
  3. delete rows based on a criteria
    By Ralem in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2011, 06:47 AM
  4. delete based on criteria
    By numbersdntlie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2011, 09:53 AM
  5. delete row based on criteria
    By miso.dca in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-03-2010, 05:13 AM

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