Or even Application.Round or just Worksheetfunction.Round

--
Regards,
Tom Ogilvy

"Ron Rosenfeld" wrote in message
...
On Tue, 9 Sep 2003 11:03:21 -0400, tomhaddock

wrote:

Thanks Tom!

You have saved me a lot of time figuring out this rounding problem. I
am now using a UDF to round it the way I want rounded! I cannot
understand why the rounding functions in formula and visual basic are
different... trust Excel to make things complicated!

Tom

In VBA, if you want it to round as it does on the worksheet, you can use:

Application.WorksheetFunction.Round


--ron