Results 1 to 5 of 5

ScreenUpdating not working properly

Threaded View

Mordred ScreenUpdating not working... 07-23-2010, 11:32 AM
romperstomper Re: ScreenUpdating not... 07-23-2010, 11:49 AM
Mordred Re: ScreenUpdating not... 07-23-2010, 11:57 AM
romperstomper Re: ScreenUpdating not... 07-23-2010, 11:58 AM
Mordred Re: ScreenUpdating not... 07-23-2010, 12:01 PM
  1. #1
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Thumbs up ScreenUpdating not working properly

    Hi all, my problem isn't a major one but it is a curious one. I've been working on an automating data transfers and was told to use this code to stop the risk of siezure:

    Application.ScreenUpdating = False
      Code
    Application.ScreenUpdating = True
    It has worked great for me but today I opened the workbook and the jumping screens are back. Not for every Sub but only for one, even though it has the ScreenUpdating code.

    I've uploaded the workbook. The problem is located in Module2 Sub "SourceTransfer"
    Can someone run this and let me know if it is an Excel bug or if I have done something wrong?
    To run it, copy the data from Sheet1 and paste it into cell B2 of Insert sheet.

    Thank you.
    Attached Files Attached Files
    Last edited by Mordred; 07-23-2010 at 12:01 PM.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1