Round UP to Whole number - VBA

[wrightyrx7]

Hi all,

The question is in the title really haha

If my value is a decimal I want to round a decimal UP to a whole number.

Regardless of the value, if the value is a decimal e.g 1.01 would still be rounded up to 2.


Thank you
Chris

 

[JackDanIce]

Try:

Dim RoundVal as Long
RoundVal = Application.RoundUp(1.01,0)
Msgbox RoundVal

 

[wrightyrx7]

Perfect!

Thank you

 

[JackDanIce]

You're welcome, thanks for the feedback.