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?
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
