Calculation time - UsedRange

[Beate Schmitz]

Hello,

if I have a UsedRange A1:C1000 in my sheet, is there a difference in calculation time between these two formulas?:

Excel Workbook
	A	B	C
1	62	5	5
2	19	*	*
3	24	*	*
4	35	*	*
5	69	*	*
6	76	*	*
7	30	*	*
8	68	*	*
9	76	*	*
10	30	*	*
11	83	*	*
Sheet

My question is whether Excel stopps calculation of the formula in cell B1 already at the end of the UsedRange which means at A1000 too? Or does this formula calculate down to cell A65536? Does a speed-different exist between these two formulas?

 

[schielrn]

Yes there is a speed difference between the 2 and the amount of memory that is used when calculating is also higher. There are results of this posted on the board in older posts. But depending on other circumstances, you may not notice really any differences in speed.

 

[Beate Schmitz]

Hello,

thanks a lot for your reply.