isblank function in Excel VBA 2003 ???

  • Thread starter Thread starter tomcee
  • Start date Start date
T

tomcee

It appears that most all 'is' functions are available in Excel
VBA2003, that is via a 'WorksheetFunction.IsNumber' type of call.

However 'isblank' is not available. Perhaps this is an oversight?

My main work is to use 'istext' and 'isnumber', but it would be nice
to use 'isblank'.

TomC
 
If you want an ISBLANK test that works the way the worksheet function does,
just do this...

If Len(Range("A1").Formula) = 0 Then
MsgBox "Cell is blank like ISBLANK reports"
Else
MsgBox "Cell has a value or a formula in it"
End If

If you test the Value property instead of the Formula property, then you can
see if the cell is empty or, if it has a formula in it, displaying the empty
string ("").
 
Back
Top