Hi Mike,

Many, but not all, Excel worksheet functions are available to VBA.

See 'List of Worksheet Functions Available to Visual Basic' in VBA help.

The Yield and Price functions are part of the Analysis Toolpak.

You need to load the 'Analysis ToolPak - VBA' Addin to use these functions
in VBA.


---
Regards,
Norman



"mike allen" wrote in message
...
can i access, in vba, all functions that excel uses on their spreadsheets?
i am looking to use 'yield' and 'price' functions in vba. thanks