Thread: pastespecial
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Serkan[_3_] Serkan[_3_] is offline
external usenet poster
 
Posts: 10
Default 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)?
.