I know in 2003 and earlier it was not a native function. I should have
clarified. For Excel 2007, it does not seem to show up. I am still having the
same problem.

"Tom Ogilvy" wrote:

Yield comes from the Analysis toolpak. It is not an Excel native worksheet
function

If you have Analysis Tookpak VBA installed, you can call it with

(demo'd from the immediate window using the help example from Excel Help on
the Yield Function):

? Application.Run("ATPVBAEN.XLA!Yield",Range("A2"),R ange("A3"), _
Range("A4"),Range("A5"),Range("A6"),Range("A7"),Ra nge("A8"))
6.50000068807315E-02

so it produces .065 as it should (according to the help example).

--
Regards,
Tom Ogilvy


"Jaky" wrote:

Hi,
I am wondering why I can not find the Yield function in VBA. I type in
"Application.worksheetfunctions." in the VBA workspace to find the yield
function, and YIELDDISC and YIElDMAT is there, but YIELD is not there? Did
they forget to put it in VBA?