WorksheetFunction.Odd (Excel)

Returns number rounded up to the nearest odd integer.

If number is nonnumeric, Odd returns the #VALUE! error value. Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an odd integer, no rounding occurs.

Odd (Arg1)

Arg1: Number - the value to round.

Dim dblArg1 As Double: dblArg1 = 
Dim dblOdd As Double
dblOdd = WorksheetFunction.Odd(Arg1:=dblArg1)