Remove Dashed Lines from Copy Paste VBA in Excel

How to remove the flashing dashes from a copy/paste range using VBA in Excel; this removes the dashed outline that appears once a paste has been completed using a macro.

Sections:

The Code

Useful Example

Notes

The Code

Application.CutCopyMode = False

Put this piece of code anywhere after you finish copying and pasting a range.

Useful Example

Sub copy_data()

'copy the data
Range("A1:A5").Copy

'paste the data
Range("C1:C5").PasteSpecial

'remove the dashed line
Application.CutCopyMode = False

'select a single cell (deselects the copied range)
Range("A1").Select

End Sub

This code simply copies data from range A1:A5 to C1:C5.

Notice that the code to remove the dashed lines appears after the copy/paste is finished.

Deselect the Copied Range

One extra thing I did at the bottom of the code is to deselect the range of cells that was copied.

To do this, I simply selected another cell, A1, using this code: Range("A1").Select

Notes

You can test the above code to see what it looks like without the additional lines that remove the dashes and deselect the copied range, just place a single quote in front of those lines to see the result without them.

Download the attached file to get this example in Excel.