cell value

G

Gord Dibben

wasssu

User Defined Function.

Function IsEmpty(Searchrange As Range) As Boolean
IsEmpty = (Application.CountA(Searchrange) = 0)
End Function

Returns TRUE or FALSE

If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + R to open Project Explorer.

Find your workbook/project and select it.

Right-click and Insert>Module. Paste the above code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Usage is: =IsEmpty(cellref)

Gord Dibben Excel MVP
 
D

Dave Peterson

There's a worksheet function that almost does what you ask:

=isblank(a1)

But it'll return false if you have a formula or constant in the cell.
 
Top