Better to clear up that detritus.

Select all your cells (or just column Z if you want to limit it).

Edit|replace
what: (leave blank)
with: $$$$$
replace all

Followed by:
edit|Replace
what: $$$$$
with: (leave blank)
replace all

All those cells that evaluated to "" and were converted to values will be
cleaned up.

And .end(xlup) will work as it should.

Bird wrote:

YES,YES,YES! Dave you hit it on the head. Formula in Z101:Z10101 is
“=IF(COUNTA(B101:G101)=0,"",COUNTA(B101:G101))”. I then copy M:M and
PasteSpecial w/ values, in M:M, to avoid hitting on the formulas. What
is the way to “Selection.End(xlUp).Row” and hitting a formula result
other than ””?

--
Bird
------------------------------------------------------------------------
Bird's Profile: http://www.excelforum.com/member.php...o&userid=24469
View this thread: http://www.excelforum.com/showthread...hreadid=500390

--

Dave Peterson