Cells appears blank but aren't ???

[rhombus4]

Have some cells which both appear to be blank

When I do the following formulas I get different results
=ISBLANK(B12) True, =ISTEXT(B12), FALSE, =ISNUMBER(B12), FALSE
=ISBLANK(B13) FALSE, =ISTEXT(B13), True, =ISNUMBER(B13), FALSE

Also When I did a Replace and Find, (didn't enter anything in the Find field) it found both cells

I only found it when I did a pivot table and I got an empty space in the Row Labels field
PS the 11 below is actually in the Count Box and not in Row Labels as it apears

Row Labels​	Count​
11​
Yes	250​
No	83​
Maybe	3​
(blank)	20​
Grand Total	367​

 

[sandy666]

definitely something there as when I deleted all the values or cleared all the values all isblank was True

sounds good

 

[rhombus4]

Looks like it, Just realised the data is from a combobox and its possible somebody selected something in a combobox then decided to change their mind and delete it which changes the cell from isblank (true) to Isblank(False)

Code was
Sheets("Sheet1").Range("C3") = ComboBox1
so added .Value -
Sheets("Sheet1").Range("C3") = ComboBox1.Value

I'd read somewhere that .value was the default if you didn't enter anything so not sure why it worked

Is there a formula that can actually pick up whether a cell is "" or actually blank