Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2007, XP Pro.
Once agin I request your much appreciated assistance with an Excel "funny": The following code appears to run and the rest of the macro runs without any errors. However the data is NOT pasted into the cells D14 and D8 respectively. If I step through using F8 then it works, but when the macro is run using the control button it does not. No error message, just does not paste the data. Help!!! Windows("SCHOOL_MAIN_MENU.xlsm").Activate Range("K33:L33").Select Application.CutCopyMode = False Selection.Copy Windows("SCHOOL_ID.xlsm").Activate Sheets("Sheet1").Activate Range("D14").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Windows("SCHOOL_MAIN_MENU.xlsm").Activate Range("M41").Select Application.CutCopyMode = False Selection.Copy Windows("SCHOOL_ID.xlsm").Activate Sheets("Sheet1").Activate Range("D8").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code not working as expected. | Excel Discussion (Misc queries) | |||
Help !!! My code is not working as expected. | Excel Discussion (Misc queries) | |||
For Each Statement not working as expected | Excel Programming | |||
Avoiding page breaks across merged cells - Code not working as expected | Excel Programming |