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.ScreenUpdating = False turns it off and =True turns it bac
on.



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

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