Macro Question

S

sony654

When running a macro the copied cell reference remains in the "copy" mode
after the macro ends. How can I insert the escape (esc) keystroke at the end
of the macro? This action will shot off the copy mode. Thanks - sony
 
K

Ken Wright

Application.CutCopyMode = False

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
S

sony654

Ken - Thanks, that worked. Sony
--
Sony Luvy


Ken Wright said:
Application.CutCopyMode = False

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
Click to expand...
 
Top