Rounding number in VBA(2002/SP3)

Topic

New Reply

In my VBA code, I get an error for the following line with an error “Expected: =”

If isnumberic(strABOL) Then round(strABOL,2)

where, strABOL = rng.Offset(0, 1).Value

What am I doing wrong?

Reply | Quote

Replies

In my VBA code, I get an error for the following line with an error “Expected: =”

If isnumberic(strABOL) Then round(strABOL,2)

where, strABOL = rng.Offset(0, 1).Value

What am I doing wrong?

Round is a function, so you must assign its return value to a variable:

Dim dblVal As Double
If IsNumeric(strABOL) Then dblVal = Round(strABOL, 2)

(Please note that it is IsNumeric, not IsNumberic)

Reply | Quote

Round is a function, so you must assign its return value to a variable:

Dim dblVal As Double
If IsNumeric(strABOL) Then dblVal = Round(strABOL, 2)

(Please note that it is IsNumeric, not IsNumberic)

Great. Thanks Hans.

Reply | Quote