Results 1 to 12 of 12

Delete Entire rows without loop with multiple partial strings criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-25-2011
    Location
    Lahore, Punjab, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    287

    Delete Entire rows without loop with multiple partial strings criteria

    I have a selection of cells

    From this selection I want to delete all rows that DO NOT [edited] have "String1" or "String2" as part of that cell.

    I have done it with loop but that takes much time. Is it possible to do this without loop?

    Note: Selection is from a single column.
    Last edited by caabdul; 03-04-2018 at 08:51 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] loop multiple criteria & delete matching rows?
    By Quint6778 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-09-2017, 09:58 AM
  2. Using loop(s) to delete rows based on criteria
    By Fish_Bio in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-09-2015, 03:02 PM
  3. [SOLVED] delete entire row if multiple criteria are satisfied
    By 4evra in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-20-2013, 08:06 AM
  4. Loop through rows and delete based on criteria
    By yolandaro30 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-27-2012, 12:23 PM
  5. Delete rows NOT containing 1 of multiple strings in a column
    By jarochnrol in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-22-2011, 05:13 PM
  6. Loop to delete rows meeting criteria
    By narrowgate88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2009, 04:54 PM
  7. delete entire rows based on a criteria
    By acekargo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2008, 11: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