+ Reply to Thread
Results 1 to 2 of 2

Range in Remove duplicates

Hybrid View

  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:
    Selection.End(xlDown).Select
    bot2 = ActiveCell.Row
    
    ' some other code
    
    Set hele = Range(Cells(2, 1), Cells(bot2, 25))
    Range(hele).RemoveDuplicates Columns:=1
    so instead I have this line:
    Range("a1").RemoveDuplicates Columns:=1
    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