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