View Single Post
  #6   Report Post  
syrhus
 
Posts: n/a
Default

I have the same problem and I found the cause of my case.
When I copy cells from a sheet and go to another sheet to paste into,if a
macro launch Worksheet.Calculate, the clipboard is cleared!!!! BUT if I
replace the worksheet.calculate function by Application.CalculateFull, Excel
keep the clipboard.

So, take care of this incredible function Calculate!!!