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:

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

Application.CutCopyMode

--
HTH

Bob Phillips

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

"Dazza" <(E-Mail Removed)> wrote in message
news:FAC2769C-9A92-465B-912D-(E-Mail Removed)...
> 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?