Clearing Office clipboard 2010
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 |
Clearing Office clipboard 2010
on 7/14/2011, avi supposed :
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 Are you saying that... Application.CutCopyMode = False ...does not clear the clipboard in XL2010? -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Clearing Office clipboard 2010
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. |
All times are GMT +1. The time now is 12:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com