VB and VBA Users Source Code: A faster version of Excel 97's round function

VB/VBA Source Code
A faster version of Excel 97's round function

By:	PXB
Email (spam proof):	Email the originator of this post
Date:	Wednesday, September 20, 2000
Hits:	782
Category:	Office

Article:
Interesting solution. However, Excel's 2000 Round function comes out as two or three times faster than this. Useful for multi-platform apps though. I would suggest changing the datatype of the NumberToRound variable to a Double instead of a Single for greater accuracy. Regards, PhilipB
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder