Autofilter Macro Failing because object variable not set

Hello, I am trying to sort and unsort some data using a toggle button. the code for the toggle button calls two macros, AFauditasc and AFAudits. The code for all three is below. the whole operation is failing on the red highlighted lines depending on which macro is being called. If I run them individually the first will work, but the second fails every time. It does not matter which macro I run first as both will fail. what am I doing wrong? The error code I am getting is Run time erro 91: Object variable or With block variable not set. Both Macros were recorded with the macro recorder.

This macro sorts the data ascending.

Please Login or Register  to view this content.

This macro sorts the data descending.

Please Login or Register  to view this content.

This is the code for the toggle button. It seems to work fine.

Please Login or Register  to view this content.

Your code leaves the autofilter in place when either of the 2 routines runs.
This means next time a routine is run the Autofilter command actually removes the autofilter which is why the clearing of the sort fails.

You need to test for the autofilter being present are applying if not.

Please Login or Register  to view this content.

Both routines will need the additional code.