I turned on the macro recorder on the current spreadsheet and called up
another spreadsheet, selected All, and pasted to the current spreadsheet
successfully. When I played back the macro, I got this message:

Select Method of Range Class failed:

The code is listed below and the error occured at Cells.Select:

ChDir "T:\ArchivePandL's"
Workbooks.Open Filename:="T:\ArchivePandL's\PL09-05.xls", UpdateLinks:=0
Selection.Copy
Windows("BchPerAuto1.xls").Activate
ActiveWindow.ScrollWorkbookTabs Position:=xlLast
Sheets("Monthly").Select
Cells.Select
Range("E1").Activate
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False