Selection change event code would be the most likely culprit. Otherwise look
at worksheet activate deactivate code... Activating code will clear the copy
area of a spreadsheet.
--
HTH...

Jim Thomlinson


"Keith" wrote:

I'm trying to copy values from one workbook that contains code, to a new
workbook that does not contain code. Both workbooks in one instance of Excel.

I did not included code to clear the clipboard, but perhaps some of my code
is causing this un-intentionally. Can you identify code that could cause this?

"Jim Thomlinson" wrote:

Are you running any code in the workbooks? Code can clear the clipboard.
other than that are you working with two workbooks in one instance of Excel
or are you working with two instances of Excel? That will cause some
difficulties with copy and paste...
--
HTH...

Jim Thomlinson


"Keith" wrote:

I have an Excel Application that works as expected. However, I am unable to
copy and paste data into another workbook. I thoughts as to what's causing
this?