Results 1 to 10 of 17

Thread: Exclude Contents From List :

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    I posted an amendment earlier.

    Another approach:
    Code:
    Sub M_snb()
        [A1:A1000] = [if(A1:A1000=B1,"",if(A1:A1000=B2,"",if(A1:A1000=B3,"",A1:A1000)))]
        Columns(1).SpecialCells(4).Delete
    End Sub

    EDIT NOTE FROM RICK ROTHSTEIN
    -------------------------------------
    Sorry, but I accidentally edited (instead of replying) to your message. I think I put it back the way you had it, but if not, I apologize.
    Last edited by Rick Rothstein; 06-07-2013 at 01:32 AM.

Similar Threads

  1. Replies: 5
    Last Post: 01-12-2013, 02:49 AM
  2. Delete List Contain Matching from Second List
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 12
    Last Post: 10-07-2012, 07:18 PM
  3. Macro for Opening files and copy the contents of the File
    By ravichandavar in forum Excel Help
    Replies: 16
    Last Post: 08-15-2012, 09:17 PM
  4. Macro to create files as per the contents in a column
    By Praveen Bj in forum Excel Help
    Replies: 1
    Last Post: 07-05-2012, 09:07 PM
  5. Replies: 4
    Last Post: 05-14-2012, 11:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •