pastespecial
 

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)?

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)?

pastespecial
 

Add these 2 lines in your macro:

Application.CutCopyMode=False
Cells(1,1).Select


-----Original Message-----
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)?
.