Thread: Error filtering for unique values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
C. Corodan C. Corodan is offline
external usenet poster
  
Posts: 9
Default Error filtering for unique values
I have the following code:

Range("D10").Select
Range("D10:D9999").AdvancedFilter Action:=xlFilterCopy,
CopyToRange:=Range( _
"D11111"), Unique:=True

The list of unique values always has a duplicate item at the beginning, fo
rexample:

A-Customer
A-Customer
B-Customer
C-Customer
D-Customer
Not assigned

Any idea what is the error?
Reply With QuoteReply With Quote