Just to add to Jim's response.

VBA's Round and excel's =round() behave differently (xl2k and above).

But if the OP wants excel's behavior (or is running xl97), then he could use:

application.round()
in code, like:
msgbox application.round(4.6, 0)



Jim Cone wrote:


Correction...
There is no Round function in XL97. Later versions do have it.
Jim Cone

--

Dave Peterson