I have been trying to write a small sub that will take contents from the clipboard to an excel spreadsheet...I have two Workbooks open...I select the data i want to copy...hit Ctrl C...then go to the other workbook which i want to paste the values. On this sheet I have a button that runs the following macro...It worked earlier today but now every time i run it it hangs on the pastespecial line with the following error. "Runtime Error '1004' Pastespecial method of range class failed. I have tried every example i can find on the internet and nothing will work. Any ideas?
ActiveCell.PasteSpecialxlPasteValues , xlPasteSpecialOperationNone