IsBlank VBA Function Not Working

[EssoExplJoe]

I am trying use the "IsBlank" function in VBA but the compiler won't accecpt this as a function. The "IsEmpty" works ok. Why isn't the "IsBlank" function accepted by the VBA compiler?

Dim a as boolean
a=IsBlank(A1)

 

[MARK858]

You're not using a valid range and probably want IsEmpty (IsBlank is a worksheet function) , try...

a = IsEmpty(Range("A1"))

or

a = IsEmpty([A1])

or maybe

a = Len(Range("A1")) = 0

or

a = Len([A1]) = 0

 

[Scott Huish]

a=(Range("A1")="")