How to copy to clipboard?

[jp001]

I recorded the following macro:

Range("G22:P33").Select
Selection.Copy

... so as to copy data to a clipboard to then paste elsewhere, but the data
doesn't stay on the clipboard once the macro stops running (I linked it to a
button.) Am I missing an extra command or something? Thanks in advance.

[pike]

Hi jp001,

quick forum search result

http://www.excelforum.com/excel-prog...copy-data.html

[Leith Ross]

Hello jp001,

Windows protocol requires that an object release the Clipboard once it is finished with the clipboard or the object has gone out of scope. That is why your data disappeared. The clipboard contents need to be stored in memory or pasted to a worksheet before the macro code has finished. The DataObject mentioned in the link will help you keep the clipboard "alive". Remember that once data is placed on the clipboard, no other programs can use it until it is released by clearing or pasting the data.

[jp001]

Thanks for the above, but it seems my code works fine after all. I just forgot to link it to the right module when I changed it's name.