Be awa

A cell can be blank, but not empty. In cell A1 enter:

=IF(1=1,"","")

countblank(A1) will return 1 even though the cell is not empty.

In VBA IsEmpty() will return true on truely empty.
--
Gary''s Student


"tikchye_oldLearner57" wrote:

hello community

can anyone in community tell me whether is there a function to count for
"empty" cells beside the Count (counting cells that has numeric data) and
CountA (counting of cells that had filled alphanumeric data)

thanks again for helping
--
oldLearner57