View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Deselecting active cells after pasting

Recording a macro including pressing Esc immediately will show you the
appropriate VBA statement (Application.CutCopymode=False).

Regards,
Stefi


€žDazza€ť ezt Ă*rta:

Hi,

I've written VB code to copy and paste. The problem is when I go back to the
Excel environment, the cell that was copied is still active (i.e. it still
has that running border around it). To deselect the cell I press the esc key.
How can I do this in VB?