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





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

1.Use Evaluate function to execuate function