Expand Minimize

WorksheetFunction.CountBlank Method (Excel)

Counts empty cells in a specified range of cells.

expression .CountBlank(Arg1)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Range

The range from which you want to count the blank cells.

Return Value

Double

Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

Show:
© 2014 Microsoft