The Missing property returns the number of missing data values in the column from which the statistics were calculated. Returns a variant. This is a read-only property.
Syntax
object.Missing( Col )
Parameter |
Type |
Description |
Col |
Long |
optional; default=1 |
Example
This example demonstrates how to return the number of missing data values in column C.
Debug.Print "Number of Missing Values (Header) "; Stats.Missing(3)
Used by: WksStatistics object