Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

c array size is x

b array size is x2

I have the following table for example.

c(1) = b(1)

c(2)=((b(2)+1)*(c(1)+1))-1

c(3)=)(b(3)+1)*(c(2)+1))-1

c(4)=)(b(4)+1)*(c(3)+1))-1

c(5)=)(b(5)+1)*(c(4)+1))-1

How would i put these in a for statement? Again C goes until x, B goes until x2.

1 Solution

```
Const x2 = 5
'Const x = 12 'must be large enough to get through all the iterations... e.g., if x2 = 5, then x must be 12, if x2 = 10 then x must be 52, etc.
'as array c() is a function of array b(), it stand to reason that c() can be dynamic and allocate what it needs on the fly, thus the declaration,
'and the redim preserve statement
Sub forStmt()
Dim i As Long, j As Long, k As Long
Dim b(1 To x2) As Variant, c() As Variant
k = 1
For i = 1 To x2 - 2
For j = i To x2
ReDim Preserve c(k) As Variant
c(k) = IIf(j = i, b(j), (b(j) + 1) * (c(k - 1) + 1) - 1)
k = k + 1
Next j
Next i
End Sub
```

Cheers,

Dave

genFormula-r1.xlsm

Tackle projects and never again get stuck behind a technical roadblock.

Join Now
gowflow

Open in new window