Are you sure the cells you think are blank are really empty? They may contain
spaces.

next to your date type =len(a1)

drag this down. All truly blank cells will display 0

Mike

"Frank Situmorang" wrote:

Hello Experts:

After I use a copy value form the formula, then I use countA for indtending
to copy only the unempty cellc. How ever the result of the blank cell also
has been counted as unemptied cell, what's wrong with it?. I saw it is
blank, but how it counts as an unemptied cells.

Please advise

Many Thanks,

Frank