title: vba set array value to NaN
body: <p>I work with double array which are partially filled with data and then printed to a range in a n excel sheet.</p>
  
  <p>The problem is, that all values are by default 0. I would want them to be NaN (not a number), which is represented in the cells as NV(). The double array should convert to NV() automatically if possible.</p>