Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Columns(LC + 1).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Cells(1, LC + 2), Unique:=True
- Columns(LC + 2).Sort Key1:=Cells(2, LC + 2), Order1:=xlAscending, Header:=xlYes
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement