Get rid of Marching Ants without clearing the Clipboard Cache

[Pat_The_Bat]

I have a form that users fill out, and at the bottom of the form I've added a button for the user to copy the data to be able to paste into another application we use.

Right now, the button works but it leaves the marching ants on the page.
If I use application.cutcopymode=false, it gets rid of the marching ants BUT IT ALSO Clears the cache and when I go to paste in the other application, there is nothing on the clipboard.

Any suggestions?

    Range("D32:F58").Select
    Selection.Copy

 

[mole999]

Marching Ants

Hello, I work for a company and they just installed Office 2013 on my computer. As I opened excel to work my normal job; I noticed when I selected cells and hit copy....the outline of my copied cells was a dark green dash line like normal....The only difference was the dashes were not moving...

www.mrexcel.com

 

[2Took]

I have a form that users fill out, and at the bottom of the form I've added a button for the user to copy the data to be able to paste into another application we use.

Right now, the button works but it leaves the marching ants on the page.
If I use application.cutcopymode=false, it gets rid of the marching ants BUT IT ALSO Clears the cache and when I go to paste in the other application, there is nothing on the clipboard.

Any suggestions?

    Range("D32:F58").Select
    Selection.Copy

What's wrong with leaving the ants be