Fast writing in worksheets
 

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

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

Fast writing in worksheets
 

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

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

Fast writing in worksheets
 

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

Fast writing in worksheets
 

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