Application visibility

[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

 

[kkknie]

Application.ScreenUpdating = False turns it off and =True turns it bac
on.

 

[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