98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - How to Clear Excel ClipBoard
vba courses london - How to Clear Excel ClipBoard
Resolved · Low Priority · Version Standard
Thu 30 Nov 2006, 16:16Delegate Sejal said...
Sejal has attended:
Excel VBA Intro Intermediate course
How to Clear Excel ClipBoard
How do you write VBA code to clear clipboard? E.g. when you are copying and pasting lots of data this can cause you to use up excess memory and sometimes crash Excel as a result. Hence, how can you avoid this?
Fri 1 Dec 2006, 10:58
Edited on Fri 1 Dec 2006, 10:59Trainer Carlos said...
RE: How to Clear Excel ClipBoard
The quickest way to clear information from the Excel clipboard is the code line
Application.CutCopyMode = False
If used after every paste it keeps the Clipboard empty.
However you can Bypass the Clipboard by NOT using Copy and Paste. To do this:
Instead of
Sheets("London").Select
Range("H9:H16").Copy
Sheets("Yearly Total").Select
Range("D9").Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
Use
Sheets("Yearly Total").Range("D9:D16") = Sheets("London").Range("H9:H16").Value
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA tip:Stop Display Alerts In ExcelWhen creating or deleting a Worksheet in Excel you don't want Excel to inform you "A file already exists....." Or "Do you want to save this file...". |
