Signature (Visual Basic / VBA)
Public Function Count( _
ParamArray vValues() As Variant _
) As Variant
Code Example
Count(12, 34, 56) = 3
Count(12, 34, Array(56, 78, 90)) = 5 ' Example #2
Count(12, 34, "Joe", Null) = 2
Count(SampleData) = 92
Parameters
| Parameter | Description |
|---|---|
| vValues | The values that are to be counted. Can be numbers, one-dimensional numeric arrays, one-dimensional Variant arrays, one-dimensional Variant arrays with embedded arrays (as in Example #2), or any combination of these. The current setting of the StatVarType Property determines which numeric data types are recognized by this function. |
Return Value
Function returns a count of the numeric values. Only "atomic" (non-array) elements are counted. Function returns 0 (zero) if none of the arguments are numeric.