Hi, I am running into the "Run time error '1004': Autofilter method of Range Class failed" when i tried to run the macro for the auto filter that i recorded . It is a relatively simple macro, not sure why it isnt working...
Code:
Sub TopCus()
'
' TopCus Macro
'
' Keyboard Shortcut: Ctrl+Shift+T
'
ActiveSheet.Range("$A$4:$K$1112").AutoFilter Field:=11, Criteria1:="10", _
Operator:=xlTop10Items
End Sub
Please help!!! Thanks!!
W
Bookmarks