MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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