This week’s Excel VBA macro shows you how to program a cut and paste action.

Three examples are shown in the image above:

The first uses four statements to cut a range of cells, reposition the cursor, paste, and finally turn off the cut/copy mode.

The second example does the same thing, but with only one one statement.

The third example demonstrates how to dynamically move the active cell to a destination that is located relative to the original location.