Copy to clipboard button on / paste special button.

In the first workbook you could put

Please Login or Register  to view this content.

Right click the button, assign macro, and pick that sub.

In the second workbook you would put

Please Login or Register  to view this content.

Then assign this to the button in the second workbook.

If you don't paste it right away you could lose it, and would then get an error. The ErrorHandling stuff would just exit the sub and amount to the macro doing nothing (instead of VB popping up with the error).

jdwilson:
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I will add them this time.

You don't need two sets of code or buttons, nor even the clipboard. You don't even need code if it is always the same cells & workbooks. This code assumes both workbooks are open, it can be adapted to open the other workbook

Please Login or Register  to view this content.

Thanks guys, I used jdwilson's code, only because the people that are going to be using this may not aways have both sheets open.
I wonder if you can help me, could you write code that copy's cell A1 to the clipboard and converts it to a value, so that when they go into the other sheet they can just do a ctrl-v. (I need to keep it simple for the computer illiterates in my office.)
Or maybe the code could copy cell A1, paste special (VALUES) into A2 and then copy A2 to the clipboard. Am I making sense?

EDIT: I just found another problem, the cell I am copying is 3 merged cells. Eg. Cell A,B,C1 (cell A1, B1, and C1 merged) and when I try to copy it into the other book I get the error about it not being identically sized. How would I change the code to copy the 3 cells (merged) instead of just one?

You should avoid Merged Cells, use centre across selection from the format menu instead.

The code that I gave you doesn't need pastespecial as values, & as i said it can be adapted if the other workbook needs opening.