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.
