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.

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