Strange behaviour and annoying

[pcc]

I am using Excel 2002 (Don't laugh!). I run a lot of VB code, most of which involves loading and unloading userforms, connecting to (eg) MS Access, etc, so all in all I give Excel a pretty hard ride. Sometimes (and I can't pin down any specific things that seem to cause this to happen), when code execution has completed, the leftmost (approximately 20%) of the working area of whichever sheet is uppermost is greyed out. That is, the row numbers are not visible, and the column numbers (those that fall within this area) are not visible either, There is just a pale grey rectangle where there should not be! Changing worksheets does not remove it, nor does adding new workbooks or opening other workbooks. The only way to get rid of it is to close the whole Excel app and re-open it.
I have lived with this for some time but it is annoying. Can anyone suggest a reason as to why this might be happening, and, more importantly, how to prevent it?
All suggestion welcomed.
Regards

 

[JLGWhiz]

When you see the grey bar on the left, go to Data>Ungroup.

 

[pcc]

Thanks. I will try next time it happens and let you know..
Regards

 

[JLGWhiz]

Thanks. I will try next time it happens and let you know..
Regards

You probably have some code in one of your files that groups data. If the code does not then ungroup the data before End Sub, then the Group mode remains in effect and the grey bar will display. If you can locate the code. just add a line at the end to ungroup the specified ranges and that will prevent the bar from appearing.

 

[pcc]

Thanks for replying, but that's not it. I am not grouping any data. The greyed-out area literally covers 20% of the screen. I suspect it's a memory problem since the only way to clear it seems to be to close and re-open Excel. Anyone else have any ideas? Please see attached screenshot showing the problem.

Regards.

 

[JLGWhiz]

Something is blocking the screen painting for sure. Not so sure it is because of memory. Does it do it for random files, or just for that one file?

 

[mole999]

update your graphic card drivers, how much memory, O/S versions etc

 

[pcc]

Something is blocking the screen painting for sure. Not so sure it is because of memory. Does it do it for random files, or just for that one file?

Does it randomly on random files..

 

[pcc]

update your graphic card drivers, how much memory, O/S versions etc

Life's too short. If there's no easy fix I can live with it. Thanks.