ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy method: How to remove dotted frame (https://www.excelbanter.com/excel-programming/355005-copy-method-how-remove-dotted-frame.html)

edanius

Copy method: How to remove dotted frame
 

Wondering how I could use VBA to remove the dotted frame that appears
around the area that has been copied.


--
edanius
------------------------------------------------------------------------
edanius's Profile: http://www.excelforum.com/member.php...o&userid=31771
View this thread: http://www.excelforum.com/showthread...hreadid=518657


Papou

Copy method: How to remove dotted frame
 
Hi
Application.CutCopyMode = False

HTH
Cordially
Pascal

"edanius" a écrit
dans le message de news:
...

Wondering how I could use VBA to remove the dotted frame that appears
around the area that has been copied.


--
edanius
------------------------------------------------------------------------
edanius's Profile:
http://www.excelforum.com/member.php...o&userid=31771
View this thread: http://www.excelforum.com/showthread...hreadid=518657




edanius[_2_]

Copy method: How to remove dotted frame
 

Thanks! :)


--
edanius
------------------------------------------------------------------------
edanius's Profile: http://www.excelforum.com/member.php...o&userid=31771
View this thread: http://www.excelforum.com/showthread...hreadid=518657



All times are GMT +1. The time now is 01:16 AM.

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