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
--
Sony Luvy

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 :-)
------------------------------*------------------------------*----------------



"sony654" wrote in message
...
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
--
Sony Luvy

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


"Ken Wright" wrote:

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 :-)
------------------------------Â*------------------------------Â*----------------



"sony654" wrote in message
...
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
--
Sony Luvy

You're welcome :-)

Regards
Ken........................

"sony654" wrote in message
...
Ken - Thanks, that worked. Sony
--
Sony Luvy


"Ken Wright" wrote:

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 :-)
------------------------------*------------------------------*----------------



"sony654" wrote in message
...
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
--
Sony Luvy