Blank Or Grey Area In The Left Of The Screen

Re: Blank Or Grey Area In The Left Of The Screen

Could be lack of RAM memory? Try a search of the Microsoft Knowledge Base

Re: Blank Or Grey Area In The Left Of The Screen

Hi,

I used to have the same problem on my laptop on Excel 2003 Professional. As far as I could tell, it's (like Dave suggested) an issue with a lack of RAM. When you're running a memory-intensive macro, your system starts paging memory to your hard disk, which is orders of magnitude slower than reading from RAM, and often results in paging faults. In this case the pixels on your screen don't get drawn correctly.

There really isn't a fix for the issue, except to try to consider your program, and how you can deallocate memory as you go to keep the stack at minimal size.

Re: Blank Or Grey Area In The Left Of The Screen

Long shot based on Fen's post. Try;

Sub MyMemoryHoggingMacro()
    Run "RunFasterMacros"


    'Code Here
    'Use Set MyObjVariable=Nothing when done with Objects




    Run "ResetFasterMacros"


End Sub






Sub RunFasterMacros()
    With Application
         .EnableEvents = False
         .Calculation = xlCalculationManual
         'Each Select or Activate in the macro will set back to true
         .ScreenUpdating = False
    End With
End Sub
Sub ResetFasterMacros()
    With Application
         .EnableEvents = True
         .Calculation = xlCalculationAutomatic
         .ScreenUpdating = True
    End With
End Sub