I use a macro to copy data from several colums to the next, then copy data from other excel files and paste the data into the active speadsheet I am working on.
This is all done from a macro as serveral people update the data on a daily basis.
When I run the macro I get a very annoying message of,
"Can not Empty Clipboard" with an OK button.
The can happen half way through a macro so only part of the process is complete.
I have searched and searched, probably in the wrong places like the microsoft web site, but with no luck.
I use office 97, so upgrading may solve my problem but thats not the point!
Thanx!!!
You may want to include the line:
Application.CutCopyMode = False
After each paste you do. Not positive it will work as I sometimes get this error just working in Excel, but it's worth a try.
Hope this helps,
Russell
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.
Archive of Mr Excel Message Board
