Application visibility

R

Rob Johnston

Hello

I am filling in an excel sheet after reading in values from a text file.
When I put in a new call to format the cells
as the data is filling, the application is slowing down by at least 10
times. Is there anyway I can turn the visibility
of the worksheet off while it is filling to speed it up and then turn the
visibility back on when the filling is complete.

MajikMan
 
P

pikus

If I'm understranding you correctly, and I think I am, then what you'l
want to do is put this at the beginning of your code:

Application.ScreenUpdating = False

And at the end:

Application.ScreenUpdating = True

That should increase the speed quite a bit. - Piku
 
Top