How do you handle missing values in excel vba e.g. i have a macro that creats a chart but sometimes values are missing inside the data series. how do you handle this is there any way of setting a general way of handling this in excel e.g. skip all missing values, set missing value = 0 thanks!

Missing values
Tony Maresca