Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application visibility
Application.ScreenUpdating = False turns it off and =True turns it bac
on. -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visibility of newsgroup postings | Excel Worksheet Functions | |||
Add-In Visibility | Excel Discussion (Misc queries) | |||
macro to close excel application other than application.quit | Excel Programming | |||
Visibility | Excel Programming | |||
Combobox Visibility Problems | Excel Programming |