Paste Command

[Martin]

I have a script that has the "ActiveSheet.Paste" command
as the last line. When it executes, it leaves the
message "Select destination and press ENTER or choose
Paste" on the bottom left message bar.

I have tried adding statements to move the cursor after
the paste, but the message still appears.

Is there a way to remove this message? I don't want to
confuse the end users of this script.

Thanks.

 

[Jack Schitt]

Just a thought, but have you tried adding
CutCopyMode = False
after the paste command?

 

[Martin]

I tried your suggestion, but it did not work.

Thanks.

 

[Guest]

hi,
application.cutcopymode = false should do it.

-----Original Message-----
Just a thought, but have you tried adding
CutCopyMode = False
after the paste command?

--
Return email address is not as DEEP as it appears



.

 

[Martin]

That did the trick. Thanks.

-----Original Message-----
hi,
application.cutcopymode = false should do it.
.