I would greatly appreciate if someone could help me with the coding for the following:

- use a loop to create n arrays in VBA where each array is based on a descending number of values in a named range

So assuming my named range has 10 values,

- the first array is simply the original named range with 10 values

- the second arrray will exclude the 1st value in the named range, but include the remaining 9

- the third array will exclude the 1st TWO values in the named range, but include the remaining 8 and so on

I've been trying for hours but can't get it right?

I tried to base the coding on the resize formula, but it crashed and burned.

For i = n

Arr(i) = Range("Test").Resize(i, 1)

Next i

But I think that coding applied to element i in Array Arr as opposed to creating Arr i

Any ideas?