error - Worksheet class failed

[Asrampd]

I need a macro to clear the filtering (possibly on several columns) and got this Macro off of the interweb - and when it runs it clears the filtering and leaves the filter arrows in place, but then ends with an error (having done what was required nicely). it says ...Run-time error 1004 ShowAllData method of worksheet class failed, WHAT IS WRONG ?

Sub AutoFilter_Remove()
'This macro removes any filtering in order to display all of the data but it does not remove the filter arrows
ActiveSheet.ShowAllData
End Sub

Ta.

 

[BlueHornet]

I expect that you're trying to run the macro a second time, maybe inadvertently or in a loop, when the filters have already been cleared. It's telling you that there's nothing to do now; it's already done.

If you put in a new line above that action:
On Error Resume Next

then when that line results in the error condition you're now seeing, it will be ignored and control passed to the next line in your code.

 

[Asrampd]

Excellent i'll give it a go later

Ta.