YEARFRAC and YIELD aren't worksheet functions. They are functions in the
Analysis Tool Pak. Worksheet functions refer to things built into Excel
proper, like SUM, AVERAGE, RANK, etc, that don't require add-ins.

Once you've set a reference to the ATP in your VBA project, you can call the
function simply as

x = Yield(.....)


On Tue, 31 Aug 2004 23:31:49 -0700, Torbjörn Lindström
wrote:

I like to build functions that calls Analysis Tool Pack
functins like YEARFRAC() and YIELD(). I have the add-
in "Analysis Tool Pack - VBA" (atpvbaen.xls) and Excel
2002.

I can not get it to work by using:
Application.WorksheetFunctions...