Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Hide the selected range highlighter

I have a vba loop that runs and copy/pastes ranges. Is it possible to
hide the range selection during the copy/paste procedure?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Hide the selected range highlighter

Is this the same thing you were working on? If so, the code doesn't select.

If you want to do it with the clipboard, you can't remove the marque without
loosing the range in the clipboard.

after the copy, you can do

Application.CutCopyMode = False

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
I have a vba loop that runs and copy/pastes ranges. Is it possible to
hide the range selection during the copy/paste procedure?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Hide the selected range highlighter

Thx again Tom. Your other suggestion has resolved my issue.

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
Hide Selected Objects Clara Excel Worksheet Functions 4 June 28th 09 06:00 AM
Hide all "except" the visible selected range(s)? Spiky Excel Worksheet Functions 2 August 4th 08 09:56 PM
Hide all "except" the visible selected range(s)? Pierre Excel Worksheet Functions 0 August 2nd 08 07:17 PM
Hide all "except" the visible selected range(s)? Pierre Excel Worksheet Functions 2 August 1st 08 09:21 PM
highlighter jlm@yell-o-glow Excel Discussion (Misc queries) 1 January 24th 06 05:24 PM


All times are GMT +1. The time now is 06:10 PM.

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

About Us

"It's about Microsoft Excel"