VBA copy paste (normal) working, VBA Pastespecial (not working)

Hi all!

My name is Dennis, I am new to this forum. I am a novice when it comes to programming with Excel, I am learning about intermediate formula's since a few months. I'm building my personal invoice system and bit by bit its getting more advanced and useful =)

There is one thing I am not figuring out, even with studying all 203 posts concerning the Pastespecial ability. I try to link a VBA code to a button. If that button is pressed, it should automatically paste the values of some specific cells (from the sheet Invoice) to a logbook, being another sheet. It should also recognize in which sheet (logbook) the data should be pasted based on the date value of a cell (the month of the date).

This all is more advanced, but the first step is to understand how I copy paste the data in the first place.

When I use the following VBA code I can copy paste the data successfully.

Please Login or Register  to view this content.

However, when I try the following code it does nothing:

Please Login or Register  to view this content.

Im sure its something small, but what issue am I not seeing?

my bad, I should have known After following the error it seemed a minor issue;
My excel expects me to use the format .Pastespecial .xlPasteValues instead of .Pastespecial (xlPasteValues), how odd.

Thanks for he help AB!

EDIT
I also managed to automatically select in which of the 12 sheets (monthlog) the values are pasted, though I am sure there would be a much shorter and efficient code for it, for example using the function Transpose . Now the cell H8 " from the sheet Backoffice gives the current month in number (1 t/m 12). If I finished the entire project I will try to shorten the code I'm using now below:

Please Login or Register  to view this content.