Any way to stop cell flickering after copy

[Mike375]

I have code that is copying an Excel cell but the cell flickers after. The boundaries are like dotted lines flashing It does the same when copying manually from toolbar.

Double clicking in the cell or another cell stops it but is there some way to add code to stop it happening.

 

[chergh]

Select another cell

 

[Mike375]

Tried that but no joy.

 

[DanWall]

It usually comes from recorded macros.

Instead of using

range("a1:a2").select
selection.copy
range("a3").select
activesheet.paste
etc
etc
etc

use something like:
Range("E10:F12").Copy Range("H10")

quick and easy

and no funny flashing lines.

 

[Mike375]

That works. Although I could not use that itself as I am copying cell values back to textboxes in an open Access DB. But it gave me the idea to do

[Forms]![GoToExcel]![Text1] = Range("E2")

 

[DanWall]

Good on ya Mike
Glad it worked out, and glad I could assist.