On 7/13/2011 11:32 PM, avi wrote:
Hello,

I've seen many posts regarding the subjects but do not feel that I
know how to clear programatically the Office/Excel clipboard

I'm looking for a code that will do a similar operation as clearing
manually from the clipboard window in Excel 2010

Has the issue a known and robust solution?

Best regards
Avi

Would you consider avoiding the use of the clipboard? Would this work
for your needs?

http://excelexperts.com/copy-values-vba

Bypassing Clipboard while copying values or formula in Excel

Submitted by Vishesh on 9 January, 2010 - 18:04

In VBA, to Copy Values from range A1:A5 to B1 you will generally write

Sheet1.Range("A1:A5").Copy
Sheet1.Range("B1").PasteSpecial xlPasteValues

Another method: write the following function in the code window

Sub CopyValues(rngSource As Range, rngTarget As Range)
rngTarget.Resize(rngSource.Rows.Count, rngSource.Columns.Count).Value
= rngSource.Value
End Sub

and call the above function using the following line of code wherever
you need to paste values

Call CopyValues(Sheet1.Range("A1:A5"), Sheet1.Range("B1"))

The source or target can be anywhere on any sheet or any workbook Copy
Formula You can use the similar approach like following:

Sheet1.Range("A3:A5").Formula = Sheet1.Range("A2").FormulaR1C1

Advantage of using this method of Copying Value and Formula

1. No use of Clipboard - just assigning values/formula; hence it is faster.

2. You must have observed screen flickering in some of the Excel Tools
which at times is there even after using screenupdating - but using this
there is no screen flicker.

3. Less use of memory.