Macro to Reset Filter

[garylundblad]

I am looking for a simple macro that will reset all filters in a worksheet or workbook. If you know how to do this, or better yet have the code already written, could you please post it?

Thank you very much!

Gary

 

[Hui]

ActiveSheet.ShowAllData

or have a look at:
http://stackoverflow.com/questions/21761027/excel-2013-vba-clear-all-filters-macro

 

[garylundblad]

Thank you Hui for your response, but for some reason it just returns an error "400." I also tried a solution from the link you included, and it did nothing. Most of the macros in the link you sent seem to need a little customizing and it seems to be a bit beyond my meager padawan skills. I'm uploading a file so you can see what I'm trying to do.

Thank you!

 

[Hui]

Can you please post your file and let us know what version of Excel your using?

 

[NARAYANK991]

Hi Gary ,

You have not mentioned that the filter is being applied to a table. The syntax for this is different. See your file.

Narayan

 

[garylundblad]

Thank you, thank you, thank you Narayan!!! It works

Gary

 

[garylundblad]

I tried to save this macro to my personal.xlsb file so I can use it with other workbooks, but when I try to run it from here I get a "Complile error" that says "Invalid use of Me keyword." Any idea what the problem is?

Thank you!

Gary

 

[NARAYANK991]

Hi Gary ,

The keyword Me is referring to the Activesheet , but this applies only when the code segment in which it appears is placed in the sheet section of a workbook.

If you need to have this segment from within your Personal.xlsb , then replace the keyword Me with the following :

ActiveWorkbook.Activesheet

Narayan

 

[garylundblad]

I'm sorry Hui, I'm using Excel 2013.

Gary

 

[garylundblad]

That worked, thank you again Narayan! You seem to be my guardian angel today.

I sincerely appreciate your help! These are all things I have been wanting to figure out for a long time.

Gary