Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello Group,
i read in a lot of data from a file with many lines and put in in the worksheet with cells Do Until EOF(InFile) Input #InFile, X Worksheets("test").Cells(5, Line).Value = X Zeile = Zeile + 1 Loop It seems the whole worksheet is updated for every line so the read in is very slow. Can I disable the update during readin, Application.ScreenUpdating = False does not help or is the an more effective whay to modify a long Col with ab buffer or so. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Improve speed of saving a large Excel file | Excel Discussion (Misc queries) | |||
Calculation based on 2 cols | Excel Discussion (Misc queries) | |||
Range.Select 1st pass 13 cols, 2nd paqss 25 cols twice as wide in error? | Excel Programming | |||
Cond Format:re color 2 cols, skip 2 cols | Excel Worksheet Functions | |||
Problem with speed of PasteSpecial for large ranges | Excel Programming |