Macro to connect to Paste All Clipboard Excel 2007

Closed
pennbowl Posts 3 Registration date Saturday December 22, 2012 Status Member Last seen December 29, 2012 - Dec 29, 2012 at 01:29 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Dec 30, 2012 at 01:55 AM
hello,
I wish to make a macro that will paste All from the clipboard Excel 2007 ( do the same as the Paste All Clipboard button )
The cell is A1 sheet "H"
after it has pasted there another macro to clear All (do the same as the clear all Clipboard button)
any ideas on the macro code??
Many thanks
Steve
Related:

1 response

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Dec 30, 2012 at 01:55 AM
Hi pennbowl,

You can check the below mentioned link for details on how to create Macros to control clipboard functions:

http://www.cpearson.com/Excel/clipboard.aspx

If you need a working excel file for the same, please upload your sample data file here:

https://authentification.site

Please revert for clarification.

Note: Please do not upload any file with any confidential or protected data such as name, phone numbers, etc.
0