If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Vba Error handling for missing (#NV) data point
Hello,
in my code, every chart datapoint with a value 0 is assigned the markerbackgroundcolorindex 3 (red). If however, one datapoint in the list has no value (#NV), the vba loop can't select it, consequently the code stops. How can I possibly trap that case and make the loop ..... For i = 1 to 10 ActiveChart.SeriesCollection(1).Points(i).Select With Selection .Markerbackgroundcolorindex = 3 End with .... continue correctly ? Thank you in advance. Kind regards, H.G. Lamy |
Thread Tools | |
Display Modes | |
|
|