Tables and Filters - How to remove filter on table without removing little arrows?

Hi all,

I was using the following code to check for filters on a sheet of data and then show all data.

Please Login or Register  to view this content.

It was decided to make the data on the sheet into a 'Table' and the above code does not work so I tried the following after recording a macro:

Please Login or Register  to view this content.

The problem is if a filter is applied that shows a partial of the table, the above code does not undo that type of filter. I have searched vigorously and can not find an answer.

I have tried this line of code but it removes the drop down filters from the header row and I found that it also places the little drop down arrows in the selected row when they do not exist.

Please Login or Register  to view this content.

The idea is on Workbook_Close() to run a filter so that the data is saved in the exact same form every time, so the next person opening it will see all the data sorted by a particular column.

Thanks,

TV

Izandol,

Thanks so much, that did the trick!

Cheers,

TV