counta result is wrong!

[mindmaster]

WinXP/Excell 2002

Counta($D:$D) returns 80 but there are 81 noneblank text items!

I tried: Counta($D$1:$D$65536) and still get 80.

I have gone up and down the column and there is no blank cell; as a matter
of fact, I clicked on the AutoFilter drop down button and it does not have
"blank row" in the show field.

I can use Rodney Powell's VBA function "LastCell" and it gets it right.

Anyone ever have this happen?

Thanks, Lee

 

[mindmaster]

Sorry, I found the problem: D1 had a button in it and I could not see
underneath it....D1 was blank.