Help rounding data series values

[Liz_I3]

Hi
I have the following code, that works, except I would like the sc.Value(i) to be rounded to 1 decimal point


If sc.Values(i) >= Sheets("Targets").Range("B3").Value Then
sc.Points(i).Interior.ColorIndex = 4

I have tried
If Application.WorksheetFunction.RoundUp(sc.Values(i)) >= Sheets("Targets").Range("B3").Value Then
sc.Points(i).Interior.ColorIndex = 4

But I get a message Argument not optional. Is it not possible to round data series values?

Thnaks
L

 

[tweedle]

The "Argument not optional" is referring to the second parameter of the ROUNDUP function.

Application.WorksheetFunction.RoundUp(sc.Values(i),1)

 

[Liz_I3]

Thanks very much that work

L