Very simple Advanced Filter not working in macro
Hi Bernie
Yes they have the same heading in both AB1 and AC1
Adam
"Bernie Deitrick" wrote:
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
|