Test for empty cell : Evaluate « Excel « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. Excel
3. Evaluate

Test for empty cell

 
Sub IsActiveCellEmpty()
   Dim stFunctionName As String
   Dim stCellReference As String
   stFunctionName = "ISBLANK"
   stCellReference = ActiveCell.Address
   MsgBox Evaluate(stFunctionName & "(" & stCellReference & ")")
End Sub

 

Related examples in the same category