Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Null Value
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Null Value
Maybe you could clear the cell:
somerangevariable.clearcontents or plop a formula in it: somerangevariable.formula = "=na()" ArthurJ wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
COUNTIF says Null = Blank but Blank < Null | Excel Worksheet Functions | |||
Null, "null", vbNull, vbNullString, vbEmpty | Excel Programming | |||
cell value based on null/not null in another cell | Excel Worksheet Functions | |||
When value is NOT Null | Excel Worksheet Functions |