+ Reply to Thread
Results 1 to 4 of 4

Screen Updating = False not working - need help to remove .select from code?

  1. #1
    Registered User
    Join Date
    09-20-2013
    Location
    McKees Rocks, PA
    MS-Off Ver
    Excel 2013
    Posts
    19

    Screen Updating = False not working - need help to remove .select from code?

    I am somewhat new to VBA, but have pieced together some code that works great for me.
    Unfortunately I cannot get the Screen Updating = False to work.
    From what I have googled, I believe the problem is due to using .select in my code.
    Can someone please help me rewrite this code to avoid using .select to try to get the screen updating = False to work or give me some tips or a place to look to learn how to do it myself?
    Thanks for your time.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Screen Updating = False not working - need help to remove .select from code?

    That's some real long code. I've made changes based on my assumptions. What "selections" can be removed are commented off and the equivalent code placed below. Hopefully it still does what it's supposed to.

    Please Login or Register  to view this content.
    多么想要告诉你 我好喜欢你

  3. #3
    Registered User
    Join Date
    09-20-2013
    Location
    McKees Rocks, PA
    MS-Off Ver
    Excel 2013
    Posts
    19

    Re: Screen Updating = False not working - need help to remove .select from code?

    WOW! That was so fast.
    Thank you.
    I ran it and am getting a "Compile Error - Invalid or unqualified reference" on this line:
    Please Login or Register  to view this content.

  4. #4
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Screen Updating = False not working - need help to remove .select from code?

    Try changing to:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Updating screen to false not working?
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-04-2014, 10:01 PM
  2. Replies: 1
    Last Post: 09-30-2013, 10:56 PM
  3. toggle full screen code not quite working
    By Bonnister in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2013, 04:01 PM
  4. Screen updating = false not working
    By Directlinq in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-01-2009, 04:12 AM
  5. Remove screen 'flicker' on executing code
    By peter.thompson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2006, 04:35 AM

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