MarkAndrews
Well-known Member
- Joined
- May 2, 2006
- Messages
- 1,970
- Office Version
- 2010
- Platform
- Windows
I have this code in my workbook - However, it is not copying the list to the required location - I am clueless as to why
TIA
TIA
Code:
Sheets("Paste Completions Report Here").Select
Columns("F:F").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Columns( _
"F:F"), CopyToRange:=Range("J1"), Unique:=True