Hi,
I'm using the following code to calculate all combinations of 3 variables.
found in this thread
Sub Perm()Dim rSets As Range, rOut As Range
Dim vArr As Variant, lrow As Long
Set rSets = Range("A1").CurrentRegion
ReDim vArr(1 To rSets.Columns.Count)
Set rOut = Cells(1, rSets.Columns.Count...