I have two buttons the first calls on this macro which I recorded

Sheets("FILES SENT").Selec
Selection.AutoFilter Field:=10, Criteria1:="OK Case
ActiveWindow.SmallScroll ToRight:=-
Selection.AutoFilter Field:=5, Criteria1:="=*house*"
Operator:=xlOr,
Criteria2:="=*workflow*

The macro is supposed to use two filters in columns J(ie-10) an
5(ie-E), but I get a messag
Run time error "1004"
Autofilter mehod of Range class failed

Similarly I have another button which would show all the record
again,

Sheets("FILES SENT").Selec
Selection.AutoFilter Field:=1
Selection.AutoFilter Field:=
Range("A2").Selec

Again the error shows, where am I going wrong, I'm using Office 97