Thread: pastespecial
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
papou[_7_] papou[_7_] is offline
external usenet poster
 
Posts: 41
Default pastespecial

Hello Claude
Application.CutCopyMode = False

HTH
Regards
Pascal

"Claude" a écrit dans le message de
...
Hi all
I use a macro to copy cells with pastespecial from one
sheet to another. Is there a way to get rid of
the "highlighting" around the copied cells on the first
sheet (other than selecting a cell on the first sheet and
using sendkeys {ESC} to get excel out of copy mode)?