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?

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