Copy and Paste blues.....

Feb 18th, 2002, 01:27 PM

After running a macro utilising 'copy' and 'paste', the message, "Select destination and press ENTER or choose paste" remains in the Status Bar after the macro has finished. Even worse, should the user press ENTER as instructed, the last bit of copied data is pasted into the whatever is the current active cell!

Is there any way of sending an ESCape code or similar to cancel this destructive tendency? If this has been covered before, I apologise. Many thanks for your patience.

Terry.

Juan Pablo González · Feb 18th, 2002, 01:32 PM

Application.CuyCopyMode = False

Feb 18th, 2002, 01:32 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,757	Application.CuyCopyMode = False __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 18th, 2002, 01:27 PM	#1
Guest Posts: n/a	After running a macro utilising 'copy' and 'paste', the message, "Select destination and press ENTER or choose paste" remains in the Status Bar after the macro has finished. Even worse, should the user press ENTER as instructed, the last bit of copied data is pasted into the whatever is the current active cell! Is there any way of sending an ESCape code or similar to cancel this destructive tendency? If this has been covered before, I apologise. Many thanks for your patience. Terry.