loL! I may be blonde and clueless about VBA, but I'm not totally stupid..
No, I don't delete with my spacebar. However, there used to be a if
statement in P which returns either "DELETE" or "". When the calculations
are done, to get rid of the formulas my existing macro does a
copy/paste-value. I had already thought that maybe it was leaving an
antinull (thanks broro!) and you are right. It's not a space, so I don't
know exactly what's there, but if I clear contents of the "empty" cell, your
code works (Norman). So, I guess I have to include something that truly
empties the non-empty empty cells? Does knowtrumps code do that?
-Tks guys!

"broro183" wrote:


Hi Kelli,
My first check would be that there is no conditional or other
formatting that results in the data being invisible in column P.
A couple of easy ways of quickly checking if there is anything in any
of the problem cells would be to insert a temporary column next to
column P & type in (for as many rows as needed):

= if(isblank(P1),"empty cell","something is in here")
or
= if(len(P1)=0,"empty cell","something is in here")


re spaces:" "But there's nothing on the screen!" <g "
Yep, I've had this too - good ol' workmates eh? :-)

Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=512949