Loss of caluclating precision (VBA vs Excel)

[Alex]

Hello

I performed a calcualtion in an excel worksheet using the built in formula
PMT=.

If I then do that same procedure using VBA (i.e. write a sub to calculate
PMT with the same inputs and still using PMT in VBA) I get two separate
results?

Can anybody help align my VBA result to the spreadsheet result.

As I understand it, excel treats anything in a spreadsheet as a 'Double' - I
defined my variables in VBA as Double but still got a different answer.

Does anybody have any insights? FWIW, I am simply calcualting loan
repayments...

Regards


Alex

[Niek Otten]

Hi Alex,

Did you also declare the function itself as Double?

Why not post your code, the values and the results from both methods?

--
Kind regards,

Niek Otten

"Alex" <Alex@discussions.microsoft.com> wrote in message
news:136A7168-13AF-400F-8E60-23FDD6012C46@microsoft.com...
> Hello
>
> I performed a calcualtion in an excel worksheet using the built in formula
> PMT=.
>
> If I then do that same procedure using VBA (i.e. write a sub to calculate
> PMT with the same inputs and still using PMT in VBA) I get two separate
> results?
>
> Can anybody help align my VBA result to the spreadsheet result.
>
> As I understand it, excel treats anything in a spreadsheet as a 'Double' -
> I
> defined my variables in VBA as Double but still got a different answer.
>
> Does anybody have any insights? FWIW, I am simply calcualting loan
> repayments...
>
> Regards
>
>
> Alex