LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default Code not working as expected

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code not working as expected. Ayo Excel Discussion (Misc queries) 2 May 19th 08 07:08 PM
Help !!! My code is not working as expected. Ayo Excel Discussion (Misc queries) 3 August 30th 07 10:39 PM
For Each Statement not working as expected Jacqui Excel Programming 1 November 2nd 05 12:19 PM
Avoiding page breaks across merged cells - Code not working as expected Alan Excel Programming 2 September 26th 05 03:55 AM


All times are GMT +1. The time now is 11:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"