isblank function in Excel VBA 2003 ???
 

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

isblank function in Excel VBA 2003 ???
 

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 ("").

--
Rick (MVP - Excel)


"tomcee" wrote in message
...
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