Copying in VBA

I have a question and I would appreciate any tips. I have coded a
command button that allows for copying some data from one worksheet to
another. But when I go back to the worksheet copied from the range is
still selected for copying. How can I make sure my user doesn't see
this?

Thanks!
Julia

Application.CutCopyMode = False

--

HTH

RP
(remove nothere from the email address if mailing direct)


<[email protected]> wrote in message
news:[email protected]...
> I have a question and I would appreciate any tips. I have coded a
> command button that allows for copying some data from one worksheet to
> another. But when I go back to the worksheet copied from the range is
> still selected for copying. How can I make sure my user doesn't see
> this?
>
> Thanks!
> Julia
>

> But when I go back to the worksheet copied from the range is
> still selected for copying. How can I make sure my user doesn't see
> this?
>

Add

Application.CutCopyMode=False

after the paste is done.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com