WorksheetFunction.Combina (Excel)

Returns the number of combinations with repetitions for a given number of items.

Combina (Arg1, Arg2)

Dim dblArg1 As Double: dblArg1 = 
Dim dblArg2 As Double: dblArg2 = 
Dim dblCombina As Double
dblCombina = WorksheetFunction.Combina(Arg1:=dblArg1, Arg2:=dblArg2)

Arguments

Arg1 (Double) - The total number of items.

Arg2 (Double) - The number of items in each combination.