Hi i have a macro which worked in excel 2007 but since our company has changed to 2010 i doesnt seem to work anymore.
I keep getting runtime error 1004 "That command cannot be used on multiple selections"

This i get while running following macro part

  '' open del
    ThisWorkbook.Activate
    Sheets("Open Del").Select
    ActiveSheet.Range("$A$3:$E$1000").AutoFilter Field:=1, Criteria1:=pl_name
    Range("B3:E1000").Select
    Selection.Copy
    Workbooks(2).Activate
    Sheets("Open Del").Select
    ActiveSheet.Paste
'    Columns("E:E").Select
'    Range(Selection, Selection.End(xlToRight)).Select
'    Selection.Delete Shift:=xlToLeft
I get the error on the "ActiveSheet.Paste"

can someone please help me.

Thanks