From: Lorin on
Is there a better way or any pitfalls using

Public Function RoundUp(vNumer as Variant) as variant
' Pos numbers only are input
RoundUp = -Int(-vNumber)
End Function

to round up.

From: Rick Rothstein (MVP - VB) on
That looks like a pretty good way to do it as far as I can see (as long as
you are talking about rounding up to an integer value). And I don't see any
possible pitfalls in that method.

Rick


"Lorin" <Lorin(a)discussions.microsoft.com> wrote in message
news:C8484970-BF74-49AF-AC97-072EDEFC80E3(a)microsoft.com...
> Is there a better way or any pitfalls using
>
> Public Function RoundUp(vNumer as Variant) as variant
> ' Pos numbers only are input
> RoundUp = -Int(-vNumber)
> End Function
>
> to round up.
>