Unfilter in VBA

[bgrish3]

Hello, I have a macro where i want to unfilter all of my filters (if there are any filters). I used the "ActiveSheet.ShowAllData" and that works fine unless there are no filters. If there arent any filters that are applied, it bring up an error, is there anything i can add to make if only filter if there are applied filters and if not then it just skips it?

Thanks

[shg]

Maybe ...

Please Login or Register  to view this content.

[bgrish3]

SHG yes that worked perfectly. Thank you!

[shg]

You're welcome.