Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CLEARING THE CLIPBOARD !!! | Excel Programming | |||
clearing the office clipboard in vba | Excel Programming | |||
Transfer clipboard from Task pane clipboard(office?) content to Excel (windows?) clipboard? | Excel Programming | |||
Clearing Clipboard | Excel Programming | |||
Clearing clipboard | Excel Programming |