Run time error 1004 macro (Simple)

I have a fairly simple macro I need help with- I get the run time error 1004 when I try it

So i have a list of about 20 projects that will grow to 500, so I need to be able to create a macro so that when the ones that are "pending" or "complete" each week I can get a list of quickly with a macro

I have tried a macro that does this, but there is an error---would anyone mind looking at my excel workbook and seeing if they have suggestions?

Thank you for your time

Sub MacroH()
'
' MacroH Macro
' Macro recorded 8/17/11 by gmcneill
'
' Keyboard Shortcut: Ctrl+Shift+H
'
    Selection.AutoFilter Field:=2, Criteria1:="Complete"
    Range("A2:A44").Select
    Selection.Copy
    Selection.AutoFilter Field:=2
    Range("E7").Select
    ActiveSheet.Paste
End Sub