Error on macro to clear filters

I have a workbook I can not share due to HIPPA protected information. I'm using Excel 2013. Here is a breakdown:

Summary tab (sheet 1)
contains slicers and a summary table
slicers pull from formatted table on Falls tab (sheet 2)

People can change slicers as they see fit. They may go to the Falls sheet and they may turn on additional filters on that table.

I have a button on the Summary sheet that I want them to be able to reset all the slicers on the Summary sheet and the filters on the Falls sheet. Here is the code.

Please Login or Register  to view this content.

I am getting an error if no additional filters were turned on for the FAlls sheet. The error is: "Run-time error '1004': ShowAllData method of Worksheet class failed." How can I avoid this error?

Thanks!

Good info!

But do you really think it's that? After reading through that thread, the difference I see is my code (haha...I mean the code I got from that other guy) works as long as there are filters turned on for my table. It only throws the debug error if there are no filters turned on.

I was wondering if I just do some type of "If" it may work without the debugging error?

I'm just questioning because the errors on that other thread weren't the same errors I'm getting.

Sorry for no sample...I know that makes it harder!

If you are only throwing a code, why not evaluate if there is a filter first, and THEN clear it?

YESSSS! That's what I don't know how to do but want to figure out!!! Or...I mean...have someone on here tell me!!!!!

Thanks for all of your ideas and input. I ended up using this:

Please Login or Register  to view this content.

From: http://stackoverflow.com/questions/1...t-class-failed