Results 1 to 8 of 8

Can Excel run vba without updating the screen or causing it to flicker?

Threaded View

Modify_inc Can Excel run vba without... 06-02-2019, 01:55 PM
Marc L Re: Can Excel run vba without... 06-02-2019, 02:04 PM
Modify_inc Re: Can Excel run vba without... 06-02-2019, 02:26 PM
Sintek Re: Can Excel run vba without... 06-02-2019, 03:03 PM
jolivanes Re: Can Excel run vba without... 06-02-2019, 05:14 PM
bakerman2 Re: Can Excel run vba without... 06-02-2019, 08:22 PM
Modify_inc Re: Can Excel run vba without... 06-03-2019, 11:00 AM
Trelkrok Re: Can Excel run vba without... 06-03-2019, 02:10 PM
  1. 06-02-2019, 03:03 PM #4
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    O365 V2408
    Posts
    15,224

    Re: Can Excel run vba without updating the screen or causing it to flicker?

    Marc L means...Replace this...
    Range("BS4:BS51").Select
Selection.Copy
Range("BT4").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    With...
    Range("BS4:BS51").Copy
Range("BT4").PasteSpecial xlPasteValues
    Always avoid Select or Activate...
    Last edited by Sintek; 06-02-2019 at 03:06 PM.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Word screen flicker prevent
    By mitrozo in forum Word Programming / VBA / Macros
    Replies: 5
    Last Post: 11-01-2016, 08:14 PM
  2. Excel 2016 screen flashing between two workbooks despite screen updating turned off
    By Cumberland in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2016, 03:07 PM
  3. Screen Flicker - EXCEL 2013 Only
    By A_Pass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-19-2014, 11:31 AM
  4. Screen Flicker
    By BuzzT in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-07-2011, 11:22 AM
  5. Help stopping screen flicker due to ComboBox
    By mikeyt354 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-13-2010, 04:08 PM
  6. screen flicker
    By mark kubicki in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2005, 09:06 PM
  7. Preventing screen flicker
    By Paul in forum Excel General
    Replies: 2
    Last Post: 03-15-2005, 06:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1