The NTHNG cell has an "X" in it, even if I keep the cell blank, it won't
work. The workbook I'm pasting into is protected, but the cell is
unprotected, and that cell is referenced in a formula that can only
read numbers, or blank cells, and for some reason even if I paste a
blank cell into it, it reads that as something rather than nothing, and
it causes an error in the formula.

Basically I'm trying to find out how to write an IF statement that will
not do anything if the cell is blank. Is that possible? Or is there
another way of doing this?

Dan


--
dlb
------------------------------------------------------------------------
dlb's Profile: http://www.excelforum.com/member.php...o&userid=16483
View this thread: http://www.excelforum.com/showthread...hreadid=512432