Hello, I don't know to compile Evaluate() to roundup or ceiling in range as following code, Anyone tips for me?
VBA Code:
Sub sample2()
Cells(3, 13).Resize(10, 3).Value = Evaluate("I3:K12" & "/" & 1.2 & "+" & 0.4)
Cells(3, 13).Resize(10, 3).Value = Evaluate("ROUND(" & "I3:K12" & "/" & 1.2 & "+" & 0.4 & ",3)") 'how to roundup?
Cells(3, 13).Resize(10, 3).Value = Evaluate("CEILING(" & "I3:K12" & "/" & 1.2 & "+" & 0.4 & ",0.02)") 'how to ceiling?
End Sub