keithkemble
Board Regular
- Joined
- Feb 15, 2002
- Messages
- 160
I am having difficulty in being able to paste the output of the filter to the destination as a value.
Can anyone help please?
Selection.AdvancedFilter Action:=xlFilterInPlace, Unique:=True
Selection.Copy Destination:=Sheets("exceptions").Range("A10")
Thanks
Can anyone help please?
Selection.AdvancedFilter Action:=xlFilterInPlace, Unique:=True
Selection.Copy Destination:=Sheets("exceptions").Range("A10")
Thanks