Archive of Mr Excel Message Board


Back to Data in Excel archive index
Back to archive home

Advanced Filters

Posted by Paul Magruder on June 25, 2001 7:50 AM
Is there code to turn off the Advanced filters? Having trouble turning them off with a macro...

Thanks in Advance
Paul


Re: Advanced Filters

Posted by Ben O. on June 25, 2001 10:21 AM
Try this:

ActiveSheet.ShowAllData

or

Sheets("Sheet Name").ShowAllData

-Ben


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.