Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loss of Speed During Copy Operation
Hello:
I'm using Excel 2003. I've written a utility to transfer selected data from a 10,000 row by 20 column sheet (A) into a second sheet (B). I want to maintain any format additions (cell background color, font changes, cell comments, etc.) made by the user in sheet A, so I'm using this type of statement in the code: A.Cells(RO, COL).Copy Destination:=B.Cells(NewRO, NewCOL) I have a counter programmed onto the screen to keep track of the row the utility is working on. HERE IS THE PROBLEM: It starts out fast and then slows way down. I would like to know if there is a way to maintain the speed throughout execution of the code. It seems like there's a memory buffer which gets full (or something). Any suggestions? Thanks in advance, MARTY |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hardship letter explaining devastating loss property loss financi | Excel Discussion (Misc queries) | |||
loss of speed with excell 2007 | Excel Discussion (Misc queries) | |||
Help: Data Loss, have prev. copy of sheet | Excel Discussion (Misc queries) | |||
"ignoring" hidden cells in a copy/paste operation | Excel Discussion (Misc queries) | |||
What of these commands ruin my copy - paste operation between workbooks? | Excel Programming |