Results 1 to 1 of 1

Excel Flickering & text scroll issues

Threaded View

  1. #1
    Registered User
    Join Date
    07-27-2006
    Location
    UK
    MS-Off Ver
    Excel for MS 365 MSO
    Posts
    17

    Excel Flickering & text scroll issues

    I am experiencing a strange excel issue whereby the sheet seems to refresh itself numerous times, this is noticeable when i have an image inserted into the sheet, and this flickers and looks as though its moving - very annoying.
    Also, when i scroll down a sheet, the text often disappears or scrambles up - only visual effect of course, but all the same very strange.

    I thought it was due to the Macro issue when running VBA macro code. So i checked the macros, and they included this text:
     
    Sub SlowWithFlicker() Dim rCell As Range For Each rCell In Range("A1:A15000") rCell.Select Next rCell End Sub


    
    Sub FastWithNoFlicker()
    Dim rCell As Range
        Application.ScreenUpdating = False
            For Each rCell In Range("A1:A15000")
                rCell.Select
            Next rCell
        Application.ScreenUpdating = True
    End Sub
    This didnt make a difference, so i removed all macros, and still does it.
    Any suggestions? this has never occurred during the 10 years ive been using excel.
    Last edited by VBA Noob; 06-21-2007 at 08:18 AM.

Thread Information

Users Browsing this Thread

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

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