Okay, my macro requires opening two extra workbooks for sorting/copy/pasting
purposes, and I am working on a way to close the extras. This formula Closes
Workbook 1 which leaves Workbook 2 active, I do a Cells.Select, copy and
activate next which brings up the original workbook, then select A1 and
paste. Well the code always stops at the Line:

ActiveSheet.Paste

So what am I doing wrong?

I was going to then follow it with Wiindows("Book2").Activate and have it
close after pasting the good data over all the original document data
essentially leaving me with the single work book open. Make sense? Here is
the code:

Windows("Book1").Activate
Application.DisplayAlerts = False
ActiveWorkbook.Close savechanges:=False
Cells.Select
Selection.Copy
Windows("Book2").ActivateNext
Cells.Select
Selection.AutoFilter
Range("A1").Select
ActiveSheet.Paste
Application.DisplayAlerts = True

THANKS!!!