You can access some of Excel's functions using
Application.WorksheetFunctions, but not all. I did not see 'yield' or
'price' when I looked in the Object Browser.


"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