Speed of opeartion on array vs range

[jakopak]

I have very large sheet.
I would like to know what is generally faster method or method of first choice.

1. using For loop like following and then operate on the range
For i=a To b
Range(Cells(i,i),Cells(i+a,i+b))
Next i

or

2. Construct array from range, then operate on array, then put the output back to sheet
(I know that an array has limited size in VBA.)

Is it possible to construct master array of arrays with different dimensions?

[NeedForExcel]

In most cases, Arrays are faster.
I'd go with option 2

If you tell what you are after, it would be easier to answer..