Glory
Well-known Member
- Joined
- Mar 16, 2011
- Messages
- 640
Code:
[COLOR=darkgreen]Range("A1:A1000").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("E2"), Unique:=True[/COLOR]
Code:
[COLOR=red]Range("A1:A1000").AdvancedFilter(xlFilterCopy, Range("E2"), True)[/COLOR]
Red fails, green succeeds. But I don't understand why it's necessary to specifically name the parameters, when it's normally possible to simply type in arguments.