Something weird with vba

[cyborg18]

Hello there,
i work with Excel 2003 and when i run vba code, sometimes, my workbook freeze and i I see a gray band on the left side of the screen. Pls see my attached file.

Someone knows what the problem?

Thanks :-)

[Bob Phillips]

No file.

[Aussiebear]

Any other strange behaviour that you've noticed? Can you recall what you were trying to do when the freezing event occured? What code do you have in the workbook?

[cyborg18]

Hello,
The code, among other things, select another sheet and in order to prevent the visual shifting between sheets i entered Application.screenupdating=false before the block code and Application.screenupdating=true after the block code.
Maybe this is the problem?
Someone told me that the problem is a problem of memory.
What do u think?
Thanks

[GTO]

I think you need to attach the file. Obfuscate any sensitive data, but keep things true as to size and code.

[Aussiebear]

Hello,
The code, among other things, select another sheet and in order to prevent the visual shifting between sheets i entered Application.screenupdating=false before the block code and Application.screenupdating=true after the block code.
Maybe this is the problem?
Someone told me that the problem is a problem of memory.
What do u think?
Thanks


Possible.... How big are your workbooks? Are you tying up resources with other programs/functions at the same time?