MrExcel.com - Your One Stop for Excel Tips & Solutions

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

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

Try this:

ActiveSheet.ShowAllData

or

Sheets("Sheet Name").ShowAllData

-Ben