WorksheetFunction.CountBlank Method
Counts empty cells in a specified range of cells.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function CountBlank ( _
Arg1 As Range _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Range
Dim returnValue As Double
returnValue = instance.CountBlank(Arg1)
double CountBlank(
Range Arg1
)
Parameters
Arg1
Type: Microsoft.Office.Interop.Excel.RangeThe range from which you want to count the blank cells.
Return Value
Type: System.Double
Remarks
Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.