+ Reply to Thread
Results 1 to 2 of 2

Range in Remove duplicates

  1. #1
    Forum Contributor
    Join Date
    08-22-2005
    Location
    Denmark
    MS-Off Ver
    Excel 365
    Posts
    349

    Range in Remove duplicates

    I have a block consisting of 25 columns, 500-600 rows and a unique identifier in Col A. Sometimes I need to remove duplicates and I have tried this, but it does'nt work:
    Please Login or Register  to view this content.
    so instead I have this line:
    Please Login or Register  to view this content.
    and it works regardless of what I have put in as Range as long as it is a single cell in the worksheet.

    What is the purpose of defining the Range?

    NSV

    PS: If someone can tip me with a more elegant way of defining the number rows, I'd appreciate it.

  2. #2
    Forum Expert
    Join Date
    09-27-2011
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    1,312

    Re: Range in Remove duplicates

    Hi try to use
    .RemoveDuplicates Columns:=Array(1)
    or bettee upload the workbook with sample
    Regards

    tom1977

    If You are satisfied with my solution click the small star icon on the left to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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