Results 1 to 7 of 7

Delete rows with specific text in column

Threaded View

danieldaniel1 Delete rows with specific... 10-30-2013, 10:47 AM
alansidman Re: Delete rows with specific... 10-30-2013, 10:48 AM
alansidman Re: Delete rows with specific... 10-30-2013, 10:55 AM
danieldaniel1 Re: Delete rows with specific... 10-30-2013, 10:56 AM
danieldaniel1 Re: Delete rows with specific... 10-30-2013, 11:39 AM
alansidman Re: Delete rows with specific... 10-30-2013, 12:05 PM
danieldaniel1 Re: Delete rows with specific... 10-30-2013, 12:47 PM
  1. #1
    Registered User
    Join Date
    10-30-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    24

    Delete rows with specific text in column

    I found the following macro on another forum (unfortunately I do remember who posted it):

    Sub delete rows with ()
    
    Columns("B:B").Select
    Do Until notfound = 1
    On Error GoTo done
    Selection.Find(What:="(No risk)").Activate
    
    ActiveCell.EntireRow.delete
    Loop
    
    done: notfound = 1
    
    End Sub
    What i need help with is to also delete all rows with "(Physical Store)" in the same macro but it does not work for me.

    Thanks in advance
    Last edited by alansidman; 10-30-2013 at 10:47 AM. Reason: code tags added

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Delete / Keep rows containing specific text.
    By fluteloop in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-30-2014, 06:48 PM
  2. [SOLVED] Delete rows fi specific text
    By blue.chio in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-26-2013, 02:23 PM
  3. [SOLVED] Locate column with specific title and delete rows if predefined set of text is found
    By johnny_tc in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-25-2012, 01:57 PM
  4. [SOLVED] Delete rows that do not contain specific text
    By jahburt in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-03-2012, 04:14 PM
  5. Delete rows with specific text
    By MAYDAY in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-08-2005, 11:05 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