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.Range

  The 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.

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace