Re: "Round" not found

From: FxM (fxmanceaux_at_chello.fr)
Date: 05/22/04 

Date: Sat, 22 May 2004 22:33:48 +0200

Alan a écrit :

> I want to use "Round" in VBA. I get the message:
>
> "Sub or Function not defined"
>
> I can see the function in the Help. Am I missing a
> reference?
>
> Regards,
> Alan

Hi Alan,

As said by other eminent colleagues round is missing under XL97.
Try :

public function round97(nb,dec)
  round97 = int(nb*(10^dec)+0.5)/(10^dec)
end function

HTH
FxM