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