Why is Application.CutCopyMode False?

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

Guest

In the following example:

Sub macromaster()
Call Macro1
MsgBox (Application.CutCopyMode)
Call Macro2
End Sub

Sub Macro1()
Range("A1").Select
Selection.Copy
MsgBox (Application.CutCopyMode)
End Sub

Sub Macro2()
MsgBox (Application.CutCopyMode)
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteValues
End Sub

If I execute macromaster, it calls Macro1 which does the copy, messaging
that Application.CutCopyMode is TRUE (1). Macro2 is then called which
re-confirms that Application.CutCopyMode is still TRUE and the paste/special
works.

If, however, I in the worksheet Select A1 and type CNTRL-C or pull-down Edit
Copy and then call Macro2 directly, Macro2 reports that
Application.CutCopyMode is FALSE, and naturally the paste fails.


Why?
 
When you run macro2 or any macro by going through the menus, it clears the
clipboard if it contains a copied range as I recall.
 

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


Back
Top