SpecialCells(xlCellTypeBlanks).Count

[julhs]

Can anybody explain because I’m puzzled?
I have this that is working;

Sub CountCheckIfBlank()
On Error Resume Next
If Range("A8:A50").SpecialCells(xlCellTypeBlanks).Count = 0 Then
Range("B23").Select
End
End If
If Range("A8:A50").SpecialCells(xlCellTypeBlanks).Count > 0 Then
Range("A23").Select
End If
End Sub

When even ever I step in and hover over the "xlCellTypeBlanks" part, it shows "=4"
I’m puzzle because the sub executes as expected under first “If” and second “If” condition, BUT the "xlCellTypeBlanks" part will ALL WAYS show "=4" regardless of whether there no blanks or 10.
So what exactly is "=4" if it’s not the number of blank cells?

 

[Fluff]

It's the literal value, XlCellType enumeration (Excel)

 

[julhs]

Many thanks for the clarification Fluff
For my ongoing learning process I needed to know why it returned what it did & why, I just need to remember it in the future?!!
Thank you as always.
Julhs

 

[Fluff]

You're welcome & thanks for the feedback.