Beate Schmitz
Active Member
- Joined
- May 20, 2007
- Messages
- 392
Hello,
if I have a UsedRange A1:C1000 in my sheet, is there a difference in calculation time between these two formulas?:
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?
if I have a UsedRange A1:C1000 in my sheet, is there a difference in calculation time between these two formulas?:
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?