Gary McMaster
Well-known Member
- Joined
- Feb 8, 2009
- Messages
- 1,978
Hi All,
I'm using the VBA statement below to return a list of unique values from column A to column B (column B = Column A with no duplicates ... except 1).
It always seems to return the first value in column A twice (one duplicate). Am I doing something wrong or is this a bug?
According to help, setting the "unique" flag to true shouldn't be giving me this duplicate.
Range("A:A").AdvancedFilter xlFilterCopy, , Range("B:B"), True
Thanks very much for your input.
Gary
I'm using the VBA statement below to return a list of unique values from column A to column B (column B = Column A with no duplicates ... except 1).
It always seems to return the first value in column A twice (one duplicate). Am I doing something wrong or is this a bug?
According to help, setting the "unique" flag to true shouldn't be giving me this duplicate.
Range("A:A").AdvancedFilter xlFilterCopy, , Range("B:B"), True
Thanks very much for your input.
Gary