Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test for dups in Array
I need help on how do I test for duplicate values in an array, x()?
My code so far: Sub finddups() Dim mstrWks As Worksheet Dim myRng As Range Dim x(), i As Long, j As Long Set mstrWks = Worksheets("Master") With mstrWks Set myRng = .Range("b28", .Cells(.Rows.Count, "B").End(xlUp)) End With j = myRng.Rows.Count i = 1 With myRng For j = 1 To j ReDim x(j) x(j) = .Cells(i, 1) & .Cells(i, 2) & .Cells(i, 3) & .Cells(i, 7) i = i + 1 Next j End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
logical test, array, text and numbers | Excel Worksheet Functions | |||
Array Test | Excel Programming | |||
Test for end of array of objects? | Excel Programming | |||
Test for Single Character That is in an Array | Excel Worksheet Functions |