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