Results 1 to 3 of 3

Thread: Application.ScreenUpdating = False not working

  1. #1
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    13

    Application.ScreenUpdating = False not working

    Hi,

    Many thanx for my previous post for the best replies.
    Now i am stuck with Application.ScreenUpdating.

    My Code is:
    Code:
       Application.ScreenUpdating = False
    but it's not working it always being true.

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Hi,

    In each sub routine set the screen updating like

    Code:
    Dim lngSU               As Long
        
    With Application
        lngSU = .ScreenUpdating
        .ScreenUpdating = False
    End With
    
    'Your code
    
    Application.ScreenUpdating = lngSU
    Last edited by Admin; 04-20-2012 at 03:56 PM.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    13
    Thanx for this useful function.
    Working!

Similar Threads

  1. Application.Caller
    By Transformer in forum Familiar with Commands and Formulas
    Replies: 0
    Last Post: 05-01-2013, 12:32 PM
  2. Replies: 2
    Last Post: 12-04-2012, 02:05 PM
  3. #Value Error in Working File
    By Suhail in forum Excel Help
    Replies: 2
    Last Post: 11-19-2012, 11:39 PM
  4. UsedRange Not Working As Expected
    By littleiitin in forum Excel Help
    Replies: 2
    Last Post: 05-20-2012, 04:16 PM
  5. Excel Application.OnKey With Parameter
    By Excel Fox in forum Excel Help
    Replies: 0
    Last Post: 11-29-2011, 01:31 PM

Posting Permissions

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