Application visibility
 

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

Application visibility
 

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



--
Message posted from http://www.ExcelForum.com

Application visibility
 

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

--
Message posted from http://www.ExcelForum.com