Macro Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 :-)
------------------------------­------------------------------­----------------
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Pasting cell contents into a macro 1
Deselecting a cell in macro 2
Macro Help 1
Repeat the macro using different ranges 1
Stop Macro running when I save the workbook 1
Macro question 12
Excel Run macro upon cell edit 0

Back
Top