Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - How to Clear Excel ClipBoard
|
|
|
The UK's most regular 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 courses london - How to Clear Excel ClipBoard
Resolved · Low Priority · Version Standard
Reply 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?
For upcoming training course dates see: Pricing & availability
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
|