G Gord Dibben Nov 4, 2004 #2 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
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 Nov 4, 2004 #3 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.
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.
