Null Value

[Guest]

I have programmatically created a chart using the series collection object.
The series is initially populated with, let's say, 30 data points.
But now I want to reset the chart to temporarily show only the first data
point.
I think I need the value NA (or null).
How do I assign the "NA" or "null" value with VBA?

Thanks,
Art

 

[Dave Peterson]

Maybe you could clear the cell:
somerangevariable.clearcontents
or plop a formula in it:
somerangevariable.formula = "=na()"