How to return and handle an empty variant when an array is expected?

browncoat · Jan 22nd 2021

I have a class that has a variant array property. Sometimes this property has not been set but code attempts to get the value from it. I can't figure out how to check this without getting a type mismatch. Thanks for all help

Code

' Class property
Public Property Get Concentrations() As Variant()
If IsEmpty(mvConcentrations) Then
Concentrations = Null
Else
Concentrations = mvConcentrations
End If
End Property
Public Property Let Concentrations(conc_arr() As Variant)
mvConcentrations = conc_arr
End Property
' code that is supposed to check this property and avoid the error
If IsNull(Plate_clsReagent.Concentrations) = False Then
' do something with the array
End If

Display More

Share