LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel - the need for speed Mike Excel Discussion (Misc queries) 10 February 3rd 09 11:20 PM
Excel Charting speed MarkJames Charts and Charting in Excel 1 June 2nd 08 11:23 AM
Excel Speed Performance help randys Excel Discussion (Misc queries) 0 February 11th 08 11:17 PM
Speed of Excel Michael Excel Discussion (Misc queries) 5 January 29th 08 06:03 AM
Can you speed UP drag speed? Ryan W Excel Discussion (Misc queries) 1 October 24th 05 06:09 PM


All times are GMT +1. The time now is 01:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"