Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Very simple Advanced Filter not working in macro
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter not working correctly in macro | Excel Programming | |||
working in the Advanced Filter in 2003 Excel | Excel Discussion (Misc queries) | |||
Advanced Filter Critera using formula not working | Excel Worksheet Functions | |||
Advanced Filter not working | Excel Worksheet Functions | |||
Advanced Filter Not Working | Excel Discussion (Misc queries) |