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)


Dim variableToEvaluate As Variant
variableToEvaluate = Null

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


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.


'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


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

Excel Help