Grey area in excel

[Jayden]

I am running a program in Excel VBA 2007 where a square area turns gray in the left side of the screen in Excel, making everything invisible in it and at the same time it's also affecting every sheet whenever i am opening it the only thing which i do is that i need to restart my Excel and then it's work fine. Can anyone tell me what would be the issue ?

[Dr.pter]

According to me there is some issue 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 and at the same time check out your Excel VBA code it might happen that there would be some small mistake because of which you are facing this issue.

[Jayden]

I have checked twice each and everything is working properly don't know what would be the issue i have really got frustrated because if i try to open the same file on some another computer then it's working fine don't know whats the issue with my PC.

[Metechman]

I guess it might happen that some of Excel file might got corrupted because of which you are getting grey area in excel i would suggest you before that try to add the following code with your VBA code if you still face the same issue then i would recommend you to reinstalling Office might solve your problem

Sub MyMemory_Hogging_Macro() 
    Run "RunFasterMacros" 
       
    Run "Reset_Faster_Macros" 
     
End Sub 
 
 
 
Sub Run_Faster_Macros() 
    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