The first rate returns a negative value, the second returns a positive.

But this worked fine for me:

rt = Application.WorksheetFunction.Rate(264, 652.56, 0, -172050, 1)

so I have no idea why you are getting an error.

Bernie
MS Excel MVP

wrote in message
oups.com...
The error message is invalid procedure call or argument.

in my code

rt = rate(264, 652.56, 0, -172050,1) - gives you error

When I change the code a little bit
rt = rate(264, 640.03, 0, -172050,1) - ok

Can anyone explain a little bit why I am getting the error? Does a
little difference in payment make the trick?

Thank

-fj