About Us

Dave Peterson[_5_]

No really.

Get a faster pc???

xlb wrote:

Thank you for your response

I have tested both. The results are the same : the copy paste values is
correct and the speed is the same.

It is extremely strange. This morning, the 2000 x 50 was very fast 0.2" !
I quit Excel, do something else, try another test : 11" !
(My mesures are done with GetTickCount)

Any idea ?

Xavier

"Dave Peterson" a écrit dans le message de news:
...
You didn't actually copy|paste special|values, you just assigned the
values.

You may want to test copy|paste special|values to see if it's any quicker
(I
didn't test it):

with myRange
.copy
.pastespecial paste:=xlpastevalues
end with

xlb wrote:

Hello,

With Excel 2002, I have a VBA macro :

Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False

With MyRange
. Formula = .Value
End With

I am very surprised by the non proportionnal augmentation of the time
with
the size of the range
Example of augmentation in width
1000 x 50 : 2"
1000 x 100 : 9"
1000 x 200 : 40"

Example of augmentation in height
1000 x 20 : 1"
2000 x 20 : 13"
3000 x 20 : 29"
4000 x 20 : 45"

Example for 100.000 cells :
1000 x 100 : 9"
2000 x 50 : 28"
4000 x 25 : 57"
10000 x 10 : 79"

Is it a known problem ?
Is there a solution : other method for pasting ? sclicing in several
zones ?

Xavier

--

Dave Peterson

--

Dave Peterson

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Improve speed of saving a large Excel file	Elmer	Excel Discussion (Misc queries)	3	February 5th 07 07:15 AM
Dynamic Ranges: Speed Issue	Sige	Excel Worksheet Functions	5	December 12th 05 09:28 PM
looping through ranges: how to speed up?	fra	Excel Programming	8	June 29th 04 03:38 AM
PasteSpecial problem	Dave Peterson[_3_]	Excel Programming	2	November 6th 03 02:45 AM
PasteSpecial problem	Jim Rech	Excel Programming	0	November 4th 03 04:47 PM

Menu

About Us