Closed Thread
Results 1 to 3 of 3

Removing Unused Lines After Remove Duplicates

  1. #1
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    228

    Removing Unused Lines After Remove Duplicates

    Hello Everyone,

    I have a macro that removes duplicates for 2 columns and then pastes those 2 columns to a new worksheet. I am having an issue with the copy/paste part of it. Excel keeps copying all the way down to the last row before the remove duplicates. For example, if column A and B had 10 rows, then I did a remove duplicates and it got rid of half of them, the copy/paste would still give me 5 rows with data and 5 blank rows.

    At a small level like that, it doesn't matter, but when I have thousands of lines of data and the scroll bar goes down way too far, then it becomes a pain.

    Does anyone know how to write code so it only picks up the data thats left after a remove duplicates?

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    228

    Re: Removing Unused Lines After Remove Duplicates

    Duplicated Post. Sorry.

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Removing Unused Lines After Remove Duplicates

    Thread closed, duplicate of this thread: http://www.excelforum.com/excel-prog...54#post3408054
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Removing Unused Lines After Remove Duplicates
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-16-2013, 04:51 PM
  2. [SOLVED] Remove duplicates without removing cells (leave blank)
    By RobertOHare in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2013, 09:57 AM
  3. [SOLVED] Remove Duplicates issue...Not Removing as it should
    By trosasco in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-24-2013, 12:57 PM
  4. Comparing lines and removing duplicates
    By christya24 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2009, 02:30 PM
  5. Remove Duplicates not removing all duplicate entries
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2008, 05:32 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