Application.WorksheetFunction.Round

[Maurizio]

Hi all,
what's the difference between:

1] … Centesimi = Application.WorksheetFunction.Round((Numero - Interi) * 100, 0)
AND
2] …Centesimi = Round((Numero - Interi) * 100, 0)

…?

Tia.

 

[Juan Pablo González]

Maybe that you can drop the 0 from the second one but not the first one ?

Centesimi = Round((Numero - Interi) * 100)

 

[Maurizio]

This question because I have seen that with excel 97 often:

Centesimi = Round((Numero - Interi) * 100, 0)

give me error, not with:

Centesimi = Application.WorksheetFunction.Round((Numero - Interi) * 100, 0)

Bye

 

[Juan Pablo González]

Ahh.. I see where you're going. VBA's round is part of VB 6, which is in Excel 2000 and XP, not in 97... the same problem with Replace, Split, AddressOf, and other functions. So, try using the WorksheetFunction one then if you need compatibility with 97.

 

[Maurizio]

Hi Juan Pablo,
many thanks for your clearness!