WorksheetFunction.Complex (Excel)

Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.

If Arg1 is nonnumeric, Complex generates an error. If Arg2 is nonnumeric, Complex generates an error. If Arg3 is neither "i" nor "j", Complex generates an error.

Complex (Arg1, Arg2, Arg3)

Dim strComplex As String
strComplex = WorksheetFunction.Complex(Arg1:=, Arg2:=)

Arguments

Arg1 - The real coefficient of the complex number

Arg2 - The imaginary coefficient of the complex number

Arg3 - The suffix for the imaginary component of the complex number. If omitted, suffix is assumed to be "i"