Hi Carim.

Hope all is well with you.

So deleting with the spacebar leaves something in the cell that the
macro picks up as a "constant" or Data? Good to know.

Thanks very much!!


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=530987