PieIzq2 -

In Excel 2003 and earlier versions, the functions for imaginary numbers
require installation of the Analysis ToolPak add-in.

In Excel 2007, those functions are standard worksheet functions.

So, in Excel 2007, whether or not the Analysis ToolPak add-in is installed,
you can use IMSQRT in a worksheet cell, and you can use
WorksheetFunction.ImSqrt in VBA code.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"PieIzq2" wrote in message
...
Hi everyone, I am trying to create a program in Excel, but the Imsqrt
function is not recognized by VBA in Excel 2007. Is there a different way
in
calculating the square root in VBA.