Lots of overhead processing

[CooterBrown]

I'm writing a macro parsing a 40,000 + record sheet.
The window is scrolling up with each record that is processed. Is there a way to disable the window. I'm sure this window is creating much overhead.

Thanks,
Coot

 

[PHV]

Application.ScreenUpdating = False
' your stuff here
Application.ScreenUpdating = True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244