Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 107
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 107
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
why does the highlighter independently jump to another cell Clinton C Excel Discussion (Misc queries) 0 July 24th 08 12:39 AM
highlighter jlm@yell-o-glow Excel Discussion (Misc queries) 1 January 24th 06 05:24 PM
Excel row highlighter I_am_a_MS_user Excel Discussion (Misc queries) 4 October 10th 05 10:58 PM
Highlighter Zip Codes Excel Programming 2 June 22nd 05 07:31 PM
row highlighter numcrun Excel Programming 1 July 16th 03 01:22 PM


All times are GMT +1. The time now is 03:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"