Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub ListDups()
Dim c As Range Dim rng As Range Dim rng2 As Range Dim iRow As Long Dim iEnd As Long iEnd = Sheets("Sheet1").Range("A2").End(xlDown).Row Set rng = Sheets("Sheet1").Range("A2:A" & iEnd) iRow = 1 For Each c In rng If Application.CountIf(rng, c) 1 Then Set rng2 = Sheets("Sheet2").Range("A1:A" & iRow) If IsError(Application.Match(c, rng2, 0)) Then iRow = iRow + 1 Sheets("Sheet2").Cells(iRow, "A") = c End If End If Next c End Sub Hth, Merjet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |