View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stef[_2_] Stef[_2_] is offline
external usenet poster
 
Posts: 3
Default Excel Writing speed

Hi,

First thank everybody for your help with my previous
problems. Hope someday I will be able to help you back...

I am trying to improve my apps processing time. I would
like to know the "fastest" way to write in a workbook. I
already know the "screenupdating = false" way. I do not
know if we can transfert another way then one cell value
at a time... I heard that some people use array to
transfert data, unfortunatly my test with this method
failed.

I also have an app that is filling a range (cell by
cell). Do you know a way to fill the range and AFTER
having been filled, it write (like if you
would "disconnect" the range from the sheet so it will
not update at each change)?

Thanks again for your precious help