MyRoundedValue=Round(MyValue,0)
--
- K Dales


" wrote:

Hi, Iv assigned a value in vba to MyValue, Can somebody advise how I
round this up if the decimal is 0.5 or above, or down if below 0.5.
Regards Robert