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

Copying in VBA
 

Application.CutCopyMode = False

--

HTH

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


wrote in message
oups.com...
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

Copying in VBA
 

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