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?
--
Gary's Student (gsnu)
Bookmarks