Deselecting active cells after pasting

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

 

[Guest]

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

Regards,
Stefi


„Dazza†ezt írta:

 

[Bob Phillips]

Application.CutCopyMode

--
HTH

Bob Phillips

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