Thread: pastespecial
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Claude Claude is offline
external usenet poster
 
Posts: 36
Default 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)?