Currently, after this function call, the system clipboard gets cleared. This
is a big issue for me to run Excel automation in background (generating
reports), because user working in foreground cannot use clipboard as usual.

Clipboard is for sharing data between applications. The current
functionality of Range.Copy doesn't make any sense. Why would you copy
anything to clipboard and clear it right away, so nobody can share it? What's
the point to use the clipboard here?

There is another function Worksheet.Copy in Excel, which doesn't use the
clipboard. So, why should Range.Copy use the clipboard? I agree that
Selection.Copy and ActiveSheet.Paste should use clipboard and it's good
enough.

Ideally, there should be another optional parameter to Range.Copy function
to specify if you want to use clipboard. If user chooses to use clipboard, it
should leave the content in the clipboard, NOT clear it right away. If user
chooses not to use clipboard, clipboard should NOT be altered at all.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc