Spreadsheet.VDataWithoutMD

This property Returns/sets a variable vector as an array of doubles without missing data.

This property is read only.
Syntax Parameters Return Value 
ReadOnly Property Spreadsheet.VDataWithoutMD( _
    VarNo As Long) As Double()
VarNo [in]

Type: Long

Double()

SVB Example

Retrieving and copy variable data (with missing data removed): 

Option Base 1
Option Explicit
Sub Main
    Dim ArrayData
    Set ArrayData = ActiveSpreadsheet.VDataWithoutMD(2)
    'create a spreadsheet to display the variable's data
    Dim spr2 As New Spreadsheet
    spr2.SetSize(UBound(ArrayData), 1)
    'Get variable 2's data from the first spreadsheet
    'and copy it to the new spreadsheet
    spr2.VData(1) = ArrayData
    spr2.Visible = True
End Sub