The VBA version of round uses the "round-to-even" logic; so in this case when the last figure is a 5, it will round to the closest even number, which is what you got in the first example.