Function does not round!

Hi everyone,

I am running into an issue I can't solve right now. I've done a complex VBA add-in for my office which around 30 people uses. It always ran smooth until I made an update to one section of code.

The code is calculating areas for metal steel deck with given values and needs to round distances according to the sheet's dimensions.

It is working good on my computer and with a sample test I get a rounded value for the width (lets say 30), but on someone's pc, the round function is not applied and he gets like 27.143214.

How is it possible?

I tried the round.up and ceiling function.

His computer and Excel settings are exactly like mine.

I also tried it on his coworker's pc and it worked!

I just don't understand how a line of code can't work on one particular computer -__-'

Please Login or Register  to view this content.

Hi,

Is it only with the width and not the height?

How are the variables dTotalWidth, Deck.dsheetLength & Deck.iSideLap defined and what are their values when they are first encountered.

Upload the workbook so that we can see your problem in context and tell us how you operate it.

Nothing to see here

Can we try to eliminate the VB Environment

What happens if you just use a normal =ROUNDUP(A1) function on a worksheet. Do this in two ways
1. Create a workbook with say 27.143214 in A1 and apply the Roundup function. Then send that workbook to your colleague who gets a different result on his PC

2. Let your colleague add 27.143214 directly in his workbook on his PC and apply the function.

What happens?