Sort of emtpy cells
Posted on 2012-03-19
I have a 2003 Excel Sheet in that before it prints its does some checking of data for missing data (user form)
I have a cell that when I edit it (F2), view it, or msgbox it, its emtpy... however in my code "IsEmpty" is thinks its not emtpy. If I edit the cell and just press delete then it treats it as emtpy as nothing was in the cell and the cursor doesn't move left when I "deleted" the text).
What is causing this and how can I prevent or check for these mysterious characters? I would like to remove them so I can truly check if the cell is empty.