Deselecting active cells after pasting
 

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?

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?

Deselecting active cells after pasting
 

Application.CutCopyMode

--
HTH

Bob Phillips

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

"Dazza" wrote in message
...
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?