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...

--
Kenshyur
-----------------------------------------------------------------------
Kenshyuri's Profile: http://www.excelforum.com/member.php...fo&userid=1571
View this thread: http://www.excelforum.com/showthread.php?threadid=27241

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


Kenshyuri wrote:


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

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

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

--
s_u_res
-----------------------------------------------------------------------
s_u_resh's Profile: http://www.excelforum.com/member.php...fo&userid=1567
View this thread: http://www.excelforum.com/showthread.php?threadid=27241

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


--
ob3ron02
------------------------------------------------------------------------
ob3ron02's Profile: http://www.excelforum.com/member.php...o&userid=15450
View this thread: http://www.excelforum.com/showthread...hreadid=272413