A Macro to paste the most recent entry from the Office Clipboard

[duugg]

Hi all,

I'm doing a data/filter/advanced filter/show all/unique records to get rid of any duplicate rows. I tried creating a macro and but the macro recorder doesn't know that I want to do NOT a regular paste, but a paste from the most recent entry from the Office Clipboard.

Is there a formula and/or macro that will allow me to do this?

Thanks much

[Leith Ross]

Hello duugg,

The Office Clipboard is an applet that has no interfaces outside of the application. This is in direct contrast to the system Clipboard which allows you to freely copy and paste between applications. When using the Office Clipboard, it is all manual.

[Kenneth Hobson]

Since it is a manual method, you can use SendKeys() to automate it. However, Sendkeys should be avoided when possible. Also note that Vista users will need to disable UAC for Sendkeys to work.

[duugg]

Okay hmmm,

I am not at all familiar with "Sendkey" and have no idea what it does. This is even after reading about it in Visual Basic help. I'll mark this thread as solved and post my question as a macro question to a different thread.

Thanks

[Kenneth Hobson]

Just post here if you need help with Sendkeys for this.