Call

IsEmpty Function in Microsoft Excel


The Excel IsEmptyFunction is used to determine whether a variable has ever been initialized i.e. has a value ever been assigned to the variable.



The Basics:

 

True/False =
IsEmpty(Variable)

It is important to remember that the
IsEmptyExcel Function is only effective to use on Variant variables. The reason for that is that other variables already have a default value assigned on variable declaration. Now. let us look at an example.


Code

Dim VariableToEvaluate As Variant


 If IsEmpty(VariableToEvaluate) Then MsgBox “Message 1: Correct no value has yet been assigned to variable VariableToEvaluate”


 VariableToEvaluate = “Test value”


 If IsEmpty(VariableToEvaluate) Then MsgBox “Message 2: Correct no value has yet been assigned to variable VariableToEvaluate”


Output


Note:

An effective way to evaluate if a value has been assigned to any variable is to use the following command len(trim(Variable))>0. No matter what type of variable is used if it contains a value this function will identify it.



 


Code

 


 ‘Declare variables


 Dim StringToProcess As String’Variable string to process


 Dim arrValues() As String’String Array


 Dim A, B As Long’Value to use as a counter


 Dim tmpValue As Variant


 Dim Check As Boolean

 


 StringToProcess = ActiveSheet.Cells(2, 1).Value ‘Assign the information to process to our variable


 arrValues() = Split(StringToProcess, ” “) ‘Parse the string into a string array using a space delimiter


 Counter = 5

 

For A = LBound(arrValues) To UBound(arrValues)


 Check = IsNumeric(arrValues(A))

If Check Then


 


 ActiveSheet.Cells(Counter, 1).Value = CDbl(arrValues(A))

Counter = Counter + 1

 

End If

 

 

 

 

Next

 

 

 


Output