Fast writing in worksheets

[Kenshyuri]

I made a tool for parsing data from a text file, the parsing is quit
fine but
it takes time for excel to format and write the text in th
worksheet...

Is there any to "double-buffer" this, or disable the update unti
you've finished...

 

[keepITcool]

use an intermediate array.
then dump the array in a range. (with same size as array)

OR
disable calculation,screenupdating,displaypagebreaks




keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[s_u_resh]

Hi Friend,

You can make calculation Manual and past or write values in worksheet.
by the following vba code

Application .Calculation = xlManual
Application.ScreenUpdating = False

after your data complete set back to normal by following code

Application .Calculation = xlAutomatic
Application.ScreenUpdating = True

I hope you enjoy this.

Take care
S.Suresh

Bye by

 

[ob3ron02]

Neat trick! The speed increase was twofold on many of my macros! Thanks