Vba errors 400 and 1004

[headexperiment]

Hi,

Grateful if anyone can help.

I have a worksheet called "Front" which contains a bunch of named ranges and a couple of macro buttons.

Behind it is a sheet called "List" which contains an autofiltered table.

One of the macros on "Front" is to reset the options and clear the autofilter on "List". Code below. It sometimes works. Sometimes I get an error that just says "400". Sometimes, if I run it from the VBA window, I get a runtime 1004 error.

What am I doing wrong?

Thanks,

HE.

Sub showall()

Worksheets("Front").Range("Option_att_flag").Value = "Any"
Worksheets("Front").Range("option_gender").Value = "Any"
Worksheets("Front").Range("option_cic").Value = "Any"
Worksheets("Front").Range("option_SenLevel").Value = "Any"
Worksheets("List").ShowAllData

End Sub