bbb bag

Excel IsNull Function

The Excel IsNullFunction is used to determine whether or not a variable has a value assigned or not.

The Basics:

 True/False = IsNull(Variable)

Code

Dim variableToEvaluate As Variant
variableToEvaluate = Null

If IsNull(variableToEvaluate) Then MsgBox "The variable variableToEvaluate has no assigned value"

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

Need Support or Help?

Send us an Email, we'll get back to you asap.

Frequently Asked Questions

Our FAQ may answer some questions that you about our company & services.

Anything else we can do?

We'd love to hear from you. Contact us to see how we can help.

Hundreds of Satisfied Clients