How do I do complex numbers in Visual Basic for Excel. I
installed the analysis add in so I can now do it in
Excel. However, I want Visual Basic to manipulate
complex numbers in my program. This is part of my basic
code that doesn't work. Thanks for the help.

wks_W.Range("AY" & i).Value = WorksheetFunction.complex
(1, 2)

or

wks_W.Range("AY" & i).Value = complex(1, 2)