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.