How to use Evaluate for roundup or ceiling in range

[alee001]

Hello, I don't know to compile Evaluate() to roundup or ceiling in range as following code, Anyone tips for me?

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

 

[Fluff]

It forces the evaluate to look at cells individually, but is not needed on newer versions of Xl.

Please don't forget to update you profile.

 

[alee001]

It forces the evaluate to look at cells individually, but is not needed on newer versions of Xl.

Please don't forget to update you profile.

I learn more. Thanks.

 

[Fluff]

Glad we could & thanks for the feedback.