Can't make excel function work in visual basic

[jojo]

I really, really need help with this...

I'm trying to run the excel financial functions Price and Accrint in a visual basic program.

The normal Application.WorkSheet.Price won't work, obviously the functions are not members of the WorkSheet module...

Application.Financial.Price won't work either.

If someone could tell me how to run the functions it would be very much appreciated.

Thanks!

[Brian]

Seach XL help for "Using Microsoft Excel Worksheet Functions in Visual Basic"

This will tell you:

Sub UseFunction()
Dim myRange As Range
Set myRange = Worksheets("Sheet1").Range("A1:C10")
answer = Application.WorksheetFunction.Min(myRange)
MsgBox answer
End Sub

The functions you ask about may be due to add-ins, but I think the above will still work as long as the add-in is turned on