copy and paste special values between two workbooks

I am working with two workbooks. I am trying to copy information from workbook "wkbSrc" and paste special as values into workbook "wkbDest".

I want to copy all the cells with values from column A starting with row 2 from "wkbSrc" and paste as values in column A of "wkbDest" but starting with next empty row of "wkbDest".

As example in "wkbSrc" I have values in A2:A12. In "wbkDest" my last row of data is A81. In this example, copy A2:A12 and paste values to A82:A92.

The code works fine if I leave out the ".PasteSpecial xlPasteValues" part of the code. It is when I add this part that it won't work. Thanks in advance for any comments.

Please Login or Register  to view this content.