WorksheetFunction.Permutationa (Excel)

Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.

Permutationa (Arg1, Arg2)


Dim dblArg1 As Double: dblArg1 = 
Dim dblArg2 As Double: dblArg2 = 
Dim dblPermutationa As Double
dblPermutationa = WorksheetFunction.Permutationa(Arg1:=dblArg1, Arg2:=dblArg2)

Arguments

Arg1, Arg2

Arg1 (Double) - Total number of objects.

Arg2 (Double) - Number of objects in each permutation.