Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Code 1 works fine on A, B, C, D.
With identical data in H, I, J, K code 2 errors. What the @#$% am I overlooking? Thanks, Howard Option Explicit Sub MyDupesGone1() With Sheets("Sheet4").Range("A1", Range("D1").End(xlDown)) .RemoveDuplicates Columns:=Array(1, 2, 3, 4), _ Header:=xlNo End With End Sub Sub MyDupesGone2() With Sheets("Sheet4").Range("H1", Range("K1").End(xlDown)) .RemoveDuplicates Columns:=Array(8, 9, 10, 11), _ Header:=xlNo End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
identical formula returns #VALUE! error | Excel Discussion (Misc queries) | |||
Series with named range on several identical sheets | Charts and Charting in Excel | |||
How to lookup when range contains multiple identical entries? | Excel Discussion (Misc queries) | |||
Inexplicable difference in row hiding speed - identical code, identical machines! | Excel Programming | |||
how do i get an error message if identical data is in two or more. | Excel Programming |