removeduplicates

I cannot figure out why I am getting a "Subscript out of range" error with this line: WS.Range(Cells(1, 1), Cells(5, 3)).RemoveDuplicates Columns:=Array(2, 3), Header:=xlNo

I have a list of words. And now I'm trying to ensure that they are all unique. If I take a copy of that list and RemoveDuplicates, then that removes duplicates, IRREGARDLESS of case. I then place a COUNTIF against that list to find the duplicate which has a count of 2. I then remove all...

I process an input file created from a Database CSV file. This report has multiple cable Name entered Multiple times. After completion I want to remove duplicate cable names and put this in a Macro file by itself. With Sheets("process") .Unprotect...

Hi, I've got the following product dimensions in a single cell: <tbody> Small: 9'' H x Small: 3'' Dia x Medium: 9.5'' H x Medium: 4.25'' Dia x Large: 12'' H x Large: 4.25'' Dia My goal is to only have the word Small listed once, Medium Once, Large Once...so it would look like </tbody>...

Hi guys, I can't find a code that suits my needs, so I come to ask for your help. The basic idea I want to achieve is to have unique data in my sheet, but it's a bit more complicated then a basic RemoveDuplicates. There are some if's and but's I will try to explain as clear as I can. Col. A...

Hi, I need your help. My task here is to create a VB Macro. I have my codes here, I just copied the column from another sheet Worksheets("Report").Select Sheets("Detailed").Columns(2).Copy Destination:=Sheets("Report").Columns(1) Sheets("Detailed").Columns(9).Copy...

Hi all, I'm stumped on this one and haven't been able to find the answer through search. This comes from the macro-recorder when I remove duplicates from the last 3 columns of my range. Sub Macro1() ' Macro1 Macro Range("A1:E8").Select Application.CutCopyMode = False...

Hi The RemoveDuplicates function is very useful, but I had a really weird experience with it today. RemoveDuplicates removes the last entry in this list: <TABLE style="WIDTH: 60pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=80><COLGROUP><COL style="WIDTH: 60pt"...