Spreadsheet.DeleteCasesWithMissingData

This function creates a new spreadsheet where any cases from any variables in the variable list that have missing data are deleted.

Syntax Parameters Return Value 
Function Spreadsheet.DeleteCasesWithMissingData( _
    VarList As Variant) As Spreadsheet
 VarList [in]

The variables to be used in the creation of the subset.

Type: Variant

Spreadsheet

SVB Example

Removing missing-data cases from a spreadsheet: 

Option Base 1
Option Explicit
Sub Main
    Dim spr As Spreadsheet
    'assigns the active spreadsheet to the object spr
    Set spr = ActiveSpreadsheet
    Dim outputspr As Spreadsheet
    'assign the output spreadsheet created from the function to the spreadsheet object outputspr
    Set outputspr = spr.DeleteCasesWithMissingData("*")
    'display the spreadsheet object outputspr
    outputspr.Visible = True
End Sub