LinkBack URL
About LinkBacks
The above code won't work on my machine is X1 is empty. Any idea why this is?
Worksheets("Sheet1").Activate Range("X:X").AdvancedFilter xlFilterCopy, , Range("Z1"), True
The above code won't work on my machine is X1 is empty. Any idea why this is?Worksheets("Sheet1").Activate Range("X:X").AdvancedFilter xlFilterCopy, , Range("Z1"), True
Hi,
Advanced filter always works best with a Header as far as I can remember.
Since you are using XL 2007 you can use the remove duplicates function.
This will let you choose no headers.
Columns("X:X").Copy Destination:=Range("Z1") Range("Z:Z").RemoveDuplicates Columns:=1, Header:=xlNo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks