Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CutCopyMode=False does not work | Excel Discussion (Misc queries) | |||
Application.Visible = False | Excel Discussion (Misc queries) | |||
Application.DisplayFormulaBar Kills CutCopyMode | Excel Programming | |||
Using the Application.ScreenUpdating = False? | Excel Programming | |||
CutCopyMode = False | Excel Programming |