VBA for Escape key

[rmccafferty]

How do I do the equivalent of hitting the escape key in VBA?

When I do a copy and paste in VBA, on screen in the spreadsheet it leaves the section highlighted or outlined. I do not want to see that residual outline of the area I copied or pasted. In normal usage, I would just hit the escape key to deselect the highlighted cells. How do I do that in VBA?

 

[dscg]

For a workaround, add this at the end:

Range("A1").ClearOutline

 

[dscg]

Or this is more like it:

SendKeys ("{ESC}")

 

[EFANYoutube]

For anyone else looking
This will take the marching ants away from the cells of a copied range

Application.CutCopyMode = False

 

[lbdyck]

Marching Ants

For anyone else looking
This will take the marching ants away from the cells of a copied range

Application.CutCopyMode = False

I tried the above and the sendkeys('esc') without success. The marching ants remain.

The only solution I've found is to back out to the 1703 build

cd %programfiles%\Common Files\Microsoft Shared\ClickToRun
officec2rclient.exe /update user updatetoversion=16.0.7967.2161

And then turn off automatic updates.

I'm hopeful a better solution can be found as this was not a problem until the 1704 or 1705 update - i'm not sure which as i was told to go back to 1703.

 

[gurs]

Re: Marching Ants

Try this:

SendKeys "{ESC}"
DoEvents

Notice that the parens/quotes are different. This works for me using Excel 2016 MSO (16.0.7726.1049) 64-bit on a Win10 Pro x64 version 1703 build 15063.540.