demo'd from the immediate window:

? application.Roundup(123.456,1)
123.5

works for me.

--
Regards,
Tom Ogilvy


"dkaydkay" wrote:

I'm trying to use the Roundup worksheet function in a VBA formula and I'm
getting a "Compile Error: Sub or Function not defined". I thought I should
be able to use this function in VBA. Any help would be greatly appreciated.
Thanks!