Copy highlighter
 

When I do copy/paste in code, the highlighter around the data to be copied
remains on after the paste action and code execution. What simple code
instruction will remove this. (Esc will of course does it manually)
--
donwb

Copy highlighter
 

Use

Application.CutCopyMode = False


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"donbowyer" wrote in
message
...
When I do copy/paste in code, the highlighter around the data
to be copied
remains on after the paste action and code execution. What
simple code
instruction will remove this. (Esc will of course does it
manually)
--
donwb

Copy highlighter
 

Hi Don,

After the paste line insert:

Application.CutCopyMode = False


---
Regards,
Norman



"donbowyer" wrote in message
...
When I do copy/paste in code, the highlighter around the data to be
copied
remains on after the paste action and code execution. What simple code
instruction will remove this. (Esc will of course does it manually)
--
donwb

Copy highlighter
 

Thanks Chip & Norman
--
donwb


"Norman Jones" wrote:

Hi Don,

After the paste line insert:

Application.CutCopyMode = False


---
Regards,
Norman



"donbowyer" wrote in message
...
When I do copy/paste in code, the highlighter around the data to be
copied
remains on after the paste action and code execution. What simple code
instruction will remove this. (Esc will of course does it manually)
--
donwb