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
Code:
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
Bookmarks