Roundup in VBA

[solotoo]

Excel seems to round decimals in very odd ways. And Im having some difficulty getting the result I want.
What I want it to do is anything that isnt a whole number should be rounded up to the next whole number. eg 1.75 = 2, 4.02 = 5, 2.5=3. Im sure this is very easy for you guys, can someone please help?

[Norie]

How are you currently trying to round?

[JFamilo]

I don't know if you have an answer to this yet...

use the roundup function

Dim LNumber As Long
Dim RoundedNumber As integer

LNumber = 1.57
RoundedNumber = Application.WorksheetFunction.Roundup(LNumber,1)

Check out the help file for the roundup function in your Excel help files if you need help with the syntax.