VBA Sum rounding result??
Posted by Aron on January 17, 2002 9:18 PM
I have rslt Public'd as an integer, and the following two lines of code in two subs in the same module:
Let rslt = WorksheetFunction.Sum(ActiveWindow.Selection)
ActiveCell.Value = Format(rslt, "$#,###.#0")
If the actual sum is 345.67, this sub returns 346.00 - any clues as to what's going on??
Thanks for any help...