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