Large information on clipboard message

**khalid79m** · 10-09-2007, 11:40 AM

when I run a macro I keep getting this message when It copys and pastes

There is a large amount of information on the Clipboard. Do you want to be able to paste this information into another program later

Yes No or Cancel

the answer is always no, so i have to click no each time

but how can i get it to do this in vba

**Paul** · 10-09-2007, 11:47 AM

Hi Khalid,

Try adding this to your macro code after copying and pasting data:

Please Login or Register  to view this content.

Also, this site might give you a few tips/alternatives to simply copying and pasting data: http://www.ozgrid.com/VBA/SpeedingUpVBACode.htm (specifically the section titled 'Avoid the use of Copy and Paste whenever Possible')