Autofilters off Home Board Archive Index Data Menu Autofilters off Posted by Terry on January 27, 2002 6:21 PM What macro command would I use to turn autofilters off in a macro? Posted by Barrie Davidson on January 27, 2002 6:25 PM Range("A1:B10").AutoFilter And adjust the range to equal the range you require. Regards,BarrieBarrie Davidson