isblank function in Excel VBA 2003 ???

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
 
R

Rick Rothstein

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with ISBLANK Function 6
Excel 2003 Suppressing Errors 4
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Need help modifying code 0
To SQL Expert: VBA Function that Calls SQL Query 3
VLookup IF word in string exists within cell, use the word. 0
Excel formulae to VBA functions 5

Top