Search results for query: *

I think I figured it out. When the new workbook opens, it stops the macro. The data still remaining on the clipboard causes the "select destination and press enter..." message. So I need to have a macro on the 2nd workbook that starts up when it is opened.

Excel 2007. I made both workbooks today just trying to get it to work. If I do a specific cell or specific range I have the same problem.

I have the same issue with that code. It's like I have security setting stopping the macro from pasting on it's own. If I open a new worbook, it pastes fine. It only has this problem when I open an existing workbook. I have found many macros on the net that people have used, but on my...

Thanks for the reply. Cells.select does copy the sheet. It opens the workbook I want it to and even if I activate "Sheet 1" in the code, it still won't paste unless I hit enter.

I am trying to copy cells from one sheet, open a different existing workbook, and paste the data... Cells.Select Selection.Copy Workbooks.Open "C:\Macro Testing\copyto.xlsx" Cells.Select ActiveSheet.PasteSpecial Paste:=xlPasteValues ActiveWorkbook.Save...