ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide the selected range highlighter (https://www.excelbanter.com/excel-programming/352463-hide-selected-range-highlighter.html)

[email protected]

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?


Tom Ogilvy

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?




[email protected]

Hide the selected range highlighter
 
Thx again Tom. Your other suggestion has resolved my issue.



All times are GMT +1. The time now is 04:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com