Deselecting active cells after pasting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Recording a macro including pressing Esc immediately will show you the
appropriate VBA statement (Application.CutCopymode=False).

Regards,
Stefi


„Dazza†ezt írta:
 
Application.CutCopyMode

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top