VBA code to turn off bankers rounding

[nancymk]

I am working with our vendor on a website that downloads data into excel but some of the numbers that end in .5 are rounding down instead of up. Looking into it on the web it looks like this is due to bankers round that VBA uses. Is there a line of code that you can put at the beginning of VBA code that would change the rounding to arithmetic?

 

[RoryA]

No - you have to use Worksheetfunction.Round or Application.Round to use the same rounding that Excel does in a worksheet.