Adam,

Cell AC1 must be blank or have the same heading as the list in AB

HTH,
Bernie
MS Excel MVP


"Adam" wrote in message
...
Columns("AB:AB").AdvancedFilter Action:=xlFilterCopy,
CopyToRange:=Columns( _
"AC:AC"), Unique:=True

Simple Advanced Filter right?

Why will it not work within my macro?

i've even tried seperating it into its own macro and calling the rest of the
original macro but this still doesn't work.

Contained in column AB are codes containing letters and numbers, multiples
of these and also blank cells.

The strange thing is that if i do the AdvFilter manually first, then delete
the info and run the macro again it actually works! But this is a crazy way
of working and i need to do it regularly so any help much appreciated!

cheers