+ Reply to Thread
Results 1 to 4 of 4

Delete Multiple Lines

  1. 01-12-2016, 11:43 AM #1
    backyardfun
    backyardfun is offline
    Forum Contributor
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    200

    Delete Multiple Lines

    I need a macro that will search Column A for duplicate numbers and delete the entire row that contains those duplicates. Thanks.
    Reply With QuoteRegister To Reply
  2. 01-12-2016, 12:06 PM #2
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Delete Multiple Lines

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 01-12-2016, 03:32 PM #3
    backyardfun
    backyardfun is offline
    Forum Contributor
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    200

    Re: Delete Multiple Lines

    There are 14,000 lines and it won't finish and shuts down excel. It doesn't have to delete the row, just delete/erase the duplicate cell.
    Reply With QuoteRegister To Reply
  4. 01-12-2016, 03:49 PM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Delete Multiple Lines

    Try this instead:

    Please Login or Register  to view this content.
    Last edited by JOHN H. DAVIS; 01-12-2016 at 03:52 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Combine values from multiple cells into one cell, then delete duplicate lines
    By Ocean Zhang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2015, 07:01 PM
  2. Delete lines in a multiple cell
    By Mayyalondon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2014, 11:47 AM
  3. Import multiple text files delete rows between lines with File Name
    By coronakyk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2014, 09:53 PM
  4. [SOLVED] Need to delete multiple lines in cells but keep one
    By Javier20h in forum Excel Programming / VBA / Macros
    Replies: 42
    Last Post: 10-30-2013, 01:01 PM
  5. [SOLVED] Macro to Delete useless lines, rearrange by dates and skip lines between different days.
    By Tmc2159 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-12-2012, 02:15 PM
  6. Delete Lines 2
    By RobB11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2011, 01:20 AM
  7. [SOLVED] Is there a way to delete multiple lines at the same time beside u.
    By cherry in forum Excel General
    Replies: 2
    Last Post: 04-11-2005, 02:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1