Hi Jeff,
Thank you for your response. I'm not quite sure your suggestion will work for what I'm trying to do though. I don't care about the ones that are empty and the ones that have more than one element are an array (i.e. I only care about the scalar elements). If I do something like:
Code
Dim Possible(1 To 9, 1 To 9) As Variant
Dim L As Long
Dim i As Long, j As Long
For i = LBound(Possible, 1) To UBound(Possible, 1)
For j = LBound(Possible, 2) To UBound(Possible, 2)
If Not (IsEmpty(Possible(i, j)) Or InStr(TypeName(Possible(i,j)), "(") > 0) Then
'scalar, do some stuff here
End If
Next j
Next i
Display More
will this work the way I expect it to?