Cut, copy and paste etc

As well as setting the properties of the cell, there are methods to perform cut, copy and paste, just like the Edit menu:

ActiveCell.Clear ()

ActiveCell.ClearContents ()

ActiveCell.ClearFormats ()

ActiveCell.Copy ()

ActiveCell.Cut ()

ActiveCell.Paste ()

Note that you need to include the brackets to execute these methods.