Results 1 to 6 of 6

Screen Flicker

Threaded View

  1. #1
    Registered User
    Join Date
    12-30-2010
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2003
    Posts
    31

    Screen Flicker

    I am using a fairly small amount of code. The problem is the second section of code (which essentially just clears a range of cells if specific cell is cleared) is causing everything to run slow and flicker. By commenting out the section in question, everything is great. I find it strange that such a small condition could cause this. I have tried various VBA optimizations, but no luck.

    Any ideas, or am I stuck with it?

    Private Sub Worksheet_Change(ByVal Target As Range)

    Dim MyRange As Range
    Set MyRange = Range("$C$4:$C$10")

    If Not Intersect(Target, Range("$B$3")) Is Nothing Then
    MyRange.Value = ""
    End If

    ' The next 3 lines are the problem
    If Range("$C$3").Value = "" Then
    MyRange.Value = ""
    End If

    If Range("$C$3").Value = "monthly" Then
    Range("$C$9").Value = ""
    End If

    End Sub
    Last edited by BuzzT; 07-07-2011 at 11:22 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