How to count empty and filled user defined cells?

[rex]

In the user defined cells, how do u count if cells are empty or filled?

I'm using the IF function but it doens't work
filled cells=1 and empty cells =0

I have six rows total and another row wherein a value indicates the total
number of filled cells. The cells contain a string (house address format e.g:
2345 Smith Drive). Thanks!

 

[JuneTheSecond]

For I = 0 To shp.RowCount(visSectionUser) - 1
Debug.Print shp.CellsSRC(visSectionUser, I, visUserValue).Formula
Next
might write formula, if exists.
If not, it mght write a blank line.