Hi All,
I have the problem in using the function "ROUND" in macro.
Example:
In excel
1.5-----> ROUND(1.5,0)====> 2
But while using macro,
1.5-----> ROUND(1.5,0)====> 1
For other values, macro works fine.
My VBA code:
For j = 3 To (a + 3)
C = Range("B" & j).Value
ActiveCell.Value = Round(C, 0)
ActiveCell.Offset(1, 0).Select
Next j
Could anyone help me plz???
Bookmarks